Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so that response is value
The same cell has two formulas, IF(D30,LOG(C3/F3),IF(D3<1,LOG(C3/10)). For
example, if C3 is 1.0E+06, D3 is 100, then F3 will be 1.0E+03 (due to another formula), and the response for the first part should read 3.0. If D3 is 0, F3 will be <10 (due to another formula), and the response should read 5.0, not simply 5.0. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |