Search : in
By :

Excel If Then Statement Maximum

Last answer on Aug 26, 2009 1:55:29 am BST MPA 2010, on Aug 25, 2009 5:04:15 pm BST 
 Report this message to moderators

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

Best answers for « Excel If Then Statement Maximum » in :
Excel - Using IF statement to add 1 to total ShowExcel - Using IF statement to add 1 to total Issue Solution Note Issue I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then add + 1 to cell B35. If...
Excel - IF formulas for Printing and Calculation ShowExcel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and calculation based on true/false. Such as, if I have some dates, and I don’t need to send a notice to a...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...

1

 venkat1926, on Aug 26, 2009 1:55:29 am BST

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.

Reply to venkat1926