Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 11, 05:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 1,549
Default Formula Help PLease

See your post in public.excel.newusers



"Jennifer"
wrote in message
ng.com...
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.




  #2   Report Post  
Old June 29th 11, 05:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 9
Default Formula Help PLease

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.
  #3   Report Post  
Old July 5th 11, 10:15 PM posted to microsoft.public.excel.worksheet.functions
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
  #4   Report Post  
Old July 6th 11, 12:00 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 829
Default Formula Help PLease

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))


Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)

  #5   Report Post  
Old July 6th 11, 12:36 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Formula Help PLease

Joe

Jennifer's problem was resolved in her other posting Jun 29th over in
excel.newusers group.

Message-ID: om


Gord


On Tue, 5 Jul 2011 16:00:00 -0700, "joeu2004" wrote:

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))


Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)



  #6   Report Post  
Old July 6th 11, 12:40 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Formula Help PLease

Here is the entire thread if you'e interested in the resolution.

http://tinyurl.com/6gsqesr


Gord

On Tue, 05 Jul 2011 16:36:51 -0700, Gord Dibben wrote:

Joe

Jennifer's problem was resolved in her other posting Jun 29th over in
excel.newusers group.

Message-ID: om


Gord


On Tue, 5 Jul 2011 16:00:00 -0700, "joeu2004" wrote:

"Jennifer" wrote:
Could someone tell me what's wrong with this formula?
=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))


Well, it would be helpful if __you__ told us what is wrong with it.

That is, what does it do that you don't like? And what result do you want
when C1=C2, C1<C2 and C2C1?

We are not mindreaders. But sometimes our wild-a.s.s guesses hit the mark.
Perhaps one of the following meets your needs:

=IF(C1=C2,"",C2-C1)

or

=IF(C1=C2,"",ABS(C2-C1))

(The latter assumes you have a typo in the last term of your IF expression,
among other mistakes.)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017