Conditional use of formulas

[Guest]

Here is what I want to do (for example):

If A1 > A2 then use the formula in B1
If A1 < A2 then use the formula in B2

Two different formulas that use the same variables. In the above example,
one formula will always return a bad value so I can't just do both every time.

Thanks!

 

[Guest]

Hi Nate

use in B1

=if(a1>a2,formula,"")
in b2
=if(a1<a2,formula,"")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nate MMI" escreveu:

 

[PCLIVE]

Try this:

=if(A1>A2,formula1,formula2)