formula

  • Thread starter Thread starter George Yorks
  • Start date Start date
G

George Yorks

I am working with a worksheet. As best I can explain:
Cell b3 has a value of 4
If Cell b4=b3 than B4
If Cell b4<b3 than b4
I want to add that if:
cell b5=b4 than b4
cell b5 <B4 than b5
The Only thing I presently have written is:
IF(B4=B3,B4,IF(B4<B3,B4))
 
George,

Try something like this-

=IF(OR(B4<=B3,B5=B4),B4,IF(B5<B4,B5,"Unknown"))

You'll have to decide what you want to happen, instead of "Unknown"!

regards

JohnI
 
Hi George,

Couple of questions:
What do you want to do if B4 > B3?
What do you want to do if B5 > B4?
Also, are you checking B4 vs. B3 first,
and B4 vs. B5 second?

That will help determine the order of your IF Statements.

Thanks.
 
The arguments, as you describe them, conflict with each other.
You will either have to change them, or give precedence to one over the
other.
Re: If
B3=4
B4=3
B5=2

B4 is less then B3, so return B4 which yields *3*
BUT, B5 is less then B4, so return B5 yields *2*
CONFLICT ... or you must have one take precedence over the other.

Also, you don't describe what happens if none of the arguments return true.
B4 is greater then B3
B5 is greater then B4
--


Regards,

RD
 
Back
Top