Using multiple If statements with a negative percentage number

[davidingilbert]

Hello all.

I am attemping to create an excel sheet that displays a message when a total percentage is + or - .125%
I have the following formula for cell E9 for when it is greater than .125% - (Also see attached spreadsheet.)

=IF(E4=0,"", (IF(E6>=0.125%,"Yes, a new Pre-TIL should have been sent out.","No, a new Pre-TIL is not necessary")))

I am having issues coming up with how to do the formula for when it is -.125%. I also would like to display the same messages that currently appear for greater than .125%.

I know I am close with the above forumla, just can't figure it out.

Thanks.

Dave

[Pete_UK]

You could use this in E9:

=IF(E4=0,"",IF(OR(E6>=0.125%,E6<=-0.125%),"Yes, a new Pre-TIL should have been sent out.","No, a new Pre-TIL is not necessary"))

Another way would be to use ABS(E6) in your first formula.

Hope this helps.

Pete

[davidingilbert]

Pete - how would I integrate ABS(E6) into my first formula?

[Pete_UK]

Use that instead of E6, i.e.:

=IF(E4=0,"",IF(ABS(E6)>=0.125%,"Yes, a new Pre-TIL should have been sent out.","No, a new Pre-TIL is not necessary"))

I've also removed a pair of brackets, which weren't needed.

Hope this helps.

Pete