Previous Topic Next Topic

Excel If Then Statement Maximum

Closed
MPA 2010 - Aug 25, 2009 at 12:04 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 25, 2009 at 08:55 PM
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.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 25, 2009 at 08:55 PM
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses