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.
Configuration: Windows XP Internet Explorer 8.0
Your problem is not clear
|