Excel If Then Statement Maximum [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I am trying to do an if then filter in excel 2003. I am calculating a simple percentage, up to a maximum x. So like =A1*.25, with a maximum of 100. Maybe something like =IF((A1*.25)>100,)100 ? Or maybe it has to be less than or equal to 100. I'm not sure how to avoid making it circular because I want the calculation to be all in one cell if possible.

Thanks.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
your problem is not clear
anyhow try this formla in some other than A1

=if(A1*25>100,100,A1*25)

the formula above means
1.if A1*25>100 then put in that empty cell 100
2. if A1*25 is less than or equal to 100 then put in that empty cell the value of A1*25.

in other words as long as A1 is less than 4 the entry will be A1:25
if A1 is 4 or more then the entry will be 100

is this clear.

STUDY help file for IF function.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!