IF equation

Macker72 · Apr 2nd, 2002, 08:52 AM

Hi
Why does the following equation always return "wrong":
=IF(0.8>D2<1,D2*10,IF(D2>1,D2*100,IF(D2<0.8,D2*1000,"wrong")))
when cell D2 contains the figure 0.9?
Many thanks for your help.
Macker

AJ · Apr 2nd, 2002, 08:59 AM

I think it's the way you're expressing the first part of the formula that is causing you the problem.

Instead of 0.8>D2<1, replace it with the following...

AND(D2>0.8,D2<1)

(Assuming you mean that D2 should be in between 0.8 and 1)

Rgds
AJ

Aladin Akyurek · Apr 2nd, 2002, 09:01 AM

Quote:

On 2002-04-02 07:52, Macker72 wrote:
Hi
Why does the following equation always return "wrong":
=IF(0.8>D2<1,D2*10,IF(D2>1,D2*100,IF(D2<0.8,D2*1000,"wrong")))
when cell D2 contains the figure 0.9?
Many thanks for your help.
Macker

The condition of the first IF needs rewriting:

=IF(AND(D2>=0.8,D2<=1),D2*10,IF(D2>1,D2*100,IF(D2<0.8,D2*1000,"wrong")))

Macker72 · Apr 2nd, 2002, 09:04 AM

Thanks AJ! you got it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:52 AM	#1
Macker72 Board Regular Join Date: Mar 2002 Posts: 107	Hi Why does the following equation always return "wrong": =IF(0.8>D2<1,D210,IF(D2>1,D2100,IF(D2<0.8,D2*1000,"wrong"))) when cell D2 contains the figure 0.9? Many thanks for your help. Macker

Apr 2nd, 2002, 08:59 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	I think it's the way you're expressing the first part of the formula that is causing you the problem. Instead of 0.8>D2<1, replace it with the following... AND(D2>0.8,D2<1) (Assuming you mean that D2 should be in between 0.8 and 1) Rgds AJ

Apr 2nd, 2002, 09:04 AM	#4
Macker72 Board Regular Join Date: Mar 2002 Posts: 107	Thanks AJ! you got it!