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.
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