IF statement unable to process negatives

[reggie1000]

Hello,

I have a problem with an IF statement, i have a "sheet value" and a "Revenue" value, the sheet value may be higher or lower than the revenue value, thus giving either a + or - value, i'm trying to get a return if the difference between the sheet and revenue is less than 10%, i have tried my own formula but it won't work with negative values, i have attached a worksheet with an example

thanks reg

[jhelliar]

It is rather a brute force way of doing it but if you put the value to the power of 2 and then square root it it will become the same value but positive so the formula for cell E5 would be =IF(C5-B5=0,"",(IF((SQRT(POWER((C5-B5),2)))>C5*$E$3,A5,"")))

Hope this helps.

Jack

[NBVC]

Hello,

I have a problem with an IF statement, i have a "sheet value" and a "Revenue" value, the sheet value may be higher or lower than the revenue value, thus giving either a + or - value, i'm trying to get a return if the difference between the sheet and revenue is less than 10%, i have tried my own formula but it won't work with negative values, i have attached a worksheet with an example

thanks reg

Try using ABS():

Please Login or Register  to view this content.

[reggie1000]

thanks chaps,

works great

cheers reg