Multiple If Functions Percentage

Hey folks,

I need help with a formula..

Let's say I have a column with a ton of percentages..

Some with 500% and some with -900%

How do I create an IF function to say that if anything is above 100% it will be 100% and if anything is more than -90% it would be -90%?

Right now I have it as
=IF(cell number>100%,"100%",cell number). Am I doing this right? But now I don't know how to add in the -90%..

Thanks!

Hi ggpaul, welcome! Try this:
=IF(A1>1,1,IF(A1<-0.9,-0.9,A1))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Try

=MIN(500%,MAX(-900%,A1))

You are the man!