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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so that response is value
I'm not sure I follow your formulas as described, but if you're looking to
have your results display the "" character along with the value, then maybe this example will lead you in the right direction: Let's say cell A1 contains the value: 5.0 In B1 you put the formula: ="" & A1 B1 would display: 5.0 HTH, Elkar "Kaputa" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so that response is value
IF(D30,LOG(C3/F3),IF(D3<1,&""LOG(C3/10)).Is this what you mean,if d3<1 then
play LOG(c3/10).I hope i have the syntax right -- paul remove nospam for email addy! "Kaputa" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so that response is value
You have to re-think your formula!
It will *always* perform the *first* calculation: LOG(C3/F3) Because ... even if D3 is <1 (0.05), it's *still* 0 ! SO, the first argument is True (0), and the first calculation will execute, and the formula *stops* calculating. It never gets to even evaluate the second argument, much less calculate it. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kaputa" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so that response is value
yes i noticed that the conditions werent exclusive but thought the formula
was "illustrative" only -- paul remove nospam for email addy! "RagDyer" wrote: You have to re-think your formula! It will *always* perform the *first* calculation: LOG(C3/F3) Because ... even if D3 is <1 (0.05), it's *still* 0 ! SO, the first argument is True (0), and the first calculation will execute, and the formula *stops* calculating. It never gets to even evaluate the second argument, much less calculate it. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kaputa" wrote in message ... 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. |
Reply |
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) |