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

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History