using IF & AND in formula
here it is..
=IF(A2B2,A2+B2,IF(A2<B2,B2-A2))
Joe
Latsh wrote:
Hi.
I'm using Excel 2000, in simple terms, I need a formula for the following.
I'm working with numbers.
IF A2 is GREATER than B2, then A2+B2
OR
IF A2 is LESS than B2, then B2-A2
Thanks,
Latsh NJ
|