Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vary formula based on what another cell contains
Hello
I have a spreadsheet where I would like to create a formula that says: If cell.Offset(0, -2) contains "with GST", then formula = "cell.Offset(0, -1)/8". Elseif cell.Offset(0, -2) contains "without GST", then formula = "0" Elseif cell.Offset(0, -2) contains "ZR", then formula = "0" I'm not sure how to write the formula to look for something *contained* in the target cell, rather than checking the entire cell contents. Any help would be greatly appreciated. Thanks MMH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vary Color based on value | Charts and Charting in Excel | |||
correlation when the cell references vary | Excel Worksheet Functions | |||
how to vary cell name in formula | Excel Worksheet Functions | |||
vary the vlookup array depending on the value in a cell | Excel Worksheet Functions | |||
Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) |