IF function and ABS

  • Thread starter Thread starter Dogface
  • Start date Start date
D

Dogface

Having a very hard time with the following:

A1 B1 C1
20 10


What I need to do is calculate the differnce in cells A1 and B1 as a
percentage change from A1. If the percentage change equals or exceeds 10
percent then I need to have an asterisk placed in C1, otherwise it should be
blank.

I also have to use the ABS function.

I tried the following, but I'm getting syntax errors:

=sum(IF(ABS(B1-A1)/A1)>=.1,*,())

=IF(ABS(B1-A1)/A1>=.1;*;())

Any help is appreciated.
 
Thank you, that is what I was looking for.


Peo Sjoblom said:
Syntax, name and parenthesis errors

Try

=IF(ABS((B1-A1)/A1)>=0.1,"*","")

--

Regards,

Peo Sjoblom


should
Click to expand...
 
Back
Top