View Single Post
  #3   Report Post  
Old July 5th 11, 10:15 PM posted to microsoft.public.excel.worksheet.functions
Alan Baybut Alan Baybut is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 1
Default 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),"C2-C1"),OR(IF((C1<C2),"C2-C1"))

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 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
=if(C1=C2,"",C2-C1)

Hope that helps

Alan