Can you use multiple cells?

For instance, put your equation in A1 and then in B1:

=a1*If(a11,10,100)



nastech wrote:

060628 Embedding IF: depends on result..

Hi, is there a way to modify the following equation, to reduce from 3 legs,
e.g.:
=IF(equation1,same eq*10,same eq*100) thanks

to something like:
=equation*10(or(if<1,if10),*10 again,"") otherwise nothing

purpose
- single digit view, on narrow column, 10 (or 95) goes to # sign
custom format: #
- same in other columns with much larger equations x 3 or 4 legs will be to
much.

-----
actual equations in formula vary, and do not matter, still all (ulitmately
<1 & 10)
=IF(OR(BR9={"",0},BR9<0.02),"",IF(((CI9-CG9)/((CH9-0.0001)-CG9))1,
((CI9-CG9)/((CH9-0.0001)-CG9)*10),((CI9-CG9)/((CH9-0.0001)-CG9)*100)))

--

Dave Peterson