Solved Determine if a value is + or - 10% inside an IF formula

July 23, 2013 at 16:44:36
Specs: Windows 7
Trying to get this formula to work.
=IF(AND($E106<1.1*$F106,$E106>.9*$F106)$C106/(($E106+$F106)/2),$C106/MAX($E106,$F106))

I need to determine if a value in a cell is + or - 10% of the value in a different cell. Then if it's true calculate the true formula, if it's false calculate the false formula


See More: Determine if a value is + or - 10% inside an IF formula

Report •


#1
July 23, 2013 at 21:59:55
✔ Best Answer
It appears that you are missing a comma before the first $C106.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question