somewhat complex if statement help PLEASE!!!!

  • Thread starter matthew.poorman
  • Start date
M

matthew.poorman

Okay, so i have the following so far but need help with making additions

=IF(C4="salmon",Sheet1!D12)(C4="Jumbo Lump",Sheet1!D10)

Sheet1!D12 = the corresponding number that is assigned to the word salmon - this is a food costing sheet for my kitchen. My issue is creating a continuous statement, so if the same range where it says salmon is changed to"jumbo lump" then the corresponding number for jumbo lump would appear andthen some.

Any help would be much appreciated. I tried using the function through insert but i have not done coding in many years.

THank you!
 
J

joeu2004

i have the following so far but need help with making additions
=IF(C4="salmon",Sheet1!D12)(C4="Jumbo Lump",Sheet1!D10)
Sheet1!D12 = the corresponding number that is assigned to the
word salmon - this is a food costing sheet for my kitchen. My
issue is creating a continuous statement, so if the same range
where it says salmon is changed to "jumbo lump" then the
corresponding number for jumbo lump would appear and then some.

I do not understand your description. But perhaps this formula will work
for you:

=IF(C4="salmon",Sheet1!D12,Sheet1!D10)

Note that it is not necessary to test C4 for "jumbo lump" if those are the
only two values that C4 might have.

Alternatively:

=IF(C4="salmon",Sheet1!D12,IF(C4="jumbo lump",Sheet1!D10,0))

Change zero at the end to whatever you want.

If that does not satisfy your needs, I suggest that you provide a concrete
example with all the necessary cell references, their values, and what you
want the IF formula to return under this and that condition.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top