column to show certain percent positive AND negative

J

Jerid B

I have a spreadsheet and it shows in a column a percent. I want it to show me
*** in the clumn next to it if it had a 15% change or more. Otherwise just
left blank.
I am using this formula and it's only giving me *** in the column that has a
positive 15%. I want it to show the *** for a positive (increase) or negative
(decrease) 15%

=IF(+U260>0.08,"***","")

Thanks!
 
B

Bernard Liengme

=IF(ABS(U260)>0.08,"***","")
or
=IF(ABS(U260)>8%,"***","")

will show *** is U260 is greater than ±0.08 or 8%

For 15% use =IF(ABS(U260)>15%,"***","")

The + sign in your formula was not required
best wishes
 
J

Jerid B

PERFECT!!! Thanks so much!

Bernard Liengme said:
=IF(ABS(U260)>0.08,"***","")
or
=IF(ABS(U260)>8%,"***","")

will show *** is U260 is greater than ±0.08 or 8%

For 15% use =IF(ABS(U260)>15%,"***","")

The + sign in your formula was not required
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top