Re: IF Statement useage

Giganews Newsgroups
Subject: Re: IF Statement useage
Posted by:  Bob Phillips (bob.N…@googlemailxxx.com)
Date: Thu, 18 May 2006

=IF(M11>159,80,IF(OR(M11<90,MOD(M11,10)<>0),0*(M11/10-8)*10))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"BThrasher" <BThrash…@discussions.microsoft.com> wrote in message
news:DCB409C7-D0EF-4B59-8252-9BF3AA739E…@microsoft.com...
> I have the folowing IF statment that works well.
>
> in "P11"
>
=IF(M11=90,10,IF(M11=100,20,IF(M11=110,30,IF(M11=120,40,IF(M11=130,50,IF(M11
=140,60,IF(M11=150,70,IF(M11>159,80,))))))))
>
> The value in P11 can be from 10 to 80 based on that statment. I have tried
> to add in the front of the IF statment  "IF(M11=0,0," making it like this
>
=IF(M11=0,0,IF(M11=90,10,IF(M11=100,20,IF(M11=110,30,IF(M11=120,40,IF(M11=13
0,50,IF(M11=140,60,IF(M11=150,70,IF(M11>159,80,)))))))))
> and it always fails with an error. What am I doing wrong?

Replies

None

In response to

IF Statement useage posted by BThrasher on Thu, 18 May 2006