Using Range operator (:) In If condition
This formula will only compare P42 with P43
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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.
|