somewhat complex if statement help PLEASE!!!!

  • Thread starter Thread starter matthew.poorman
  • Start date 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!
 
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.
Click to expand...

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.
 
Back
Top