Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
somewhat complex if statement help PLEASE!!!!
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 and then 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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
somewhat complex if statement help PLEASE!!!!
wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex IF statement help | About this forum | |||
Complex IF Statement | Excel Discussion (Misc queries) | |||
Complex IF THEN statement | Excel Worksheet Functions | |||
Complex IF STATEMENT | Excel Discussion (Misc queries) | |||
Help with complex If statement | Excel Worksheet Functions |