Conditional use of formulas

N

Nate MMI

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!
 
M

Marcelo

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:
 
Top