Using Range operator (:) In If condition
=IF(AND(P42=P43,Q42=Q43),"In Balance","Out of Balance")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Soundar" wrote in message
...
I have an excel sheet, which provided by client, In that one cell contains
formula as follows:
=IF((P42:Q42)=(P43:Q43),"In Balance","Out of Balance")
As per the above formula, My understanding is, P42 should be equal to P43
and Q42 should be equal to Q43, then I will get "In Balance" as output.
When
I tried to changes the values in the cells, it is not giving "Out of
Balance"
and always showing "In balance" as output. Could you please suggest me on
this.
|