Formula Help PLease
On Jun 29, 5:51*pm, Jennifer wrote:
Could someone tell me what's wrong with this formula?
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 C2-C1 within quotes which would return the
text string "C2-C1" rather than a value.
If my assumption is right then this formula should work
Hope that helps