|Subject:||Re: IF Statement useage|
|Posted by:||Bernard Liengme (blieng…@stfx.TRUENORTH.ca)|
|Date:||Thu, 18 May 2006|
The problem is that Excel permits up to 7 level of nesting
Generally one use a lookup formula (see Help on VLOOKUP) when an IF cannot
accommodate all the choices
But in your case you could use =IF(M11=0,0,IF(M11>159,80,M11-80))
Not clear what you want when M11 is , for example, 145.
Bernard V Liengme
remove caps from email
"BThrasher" <BThrash…@discussions.microsoft.com> wrote in message
>I have the folowing IF statment that works well.
> in "P11"
> 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
> and it always fails with an error. What am I doing wrong?
IF Statement useage posted by BThrasher on Thu, 18 May 2006