Formula Help PLease
On Jun 29, 5:51*pm, Jennifer wrote:
Hi,
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2C1"),OR(IF((C1<C2),"C2C1"))
Thank you.
Hi,
I assume that what you are trying to do is show a blank cell if C1=C2
but if C1 is greater than C2, or C2 is greater than C1, then you want
to show the value of C2 minus C1?
Currently you are showing C2C1 within quotes which would return the
text string "C2C1" rather than a value.
If my assumption is right then this formula should work
=if(C1=C2,"",C2C1)
Hope that helps
Alan
