Excel If Then Statement Maximum [Closed]

Question

Excel If Then Statement Maximum [Closed]

Report

MPA 2010 - Aug 25, 2009 at 12:04 PM
venkat1926

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

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

Excel If Then Statement Maximum
Excel - Using IF statement to add 1 to total - How-To - Excel
Excel - If then statement for commission - How-To - Excel
Excel if then statements with dates - How-To - Excel
Excel multiple if statements - How-To - Excel
Multiple if statements in excel data validation - Forum - Excel

1 reply

Ask a question

venkat1926 · Accepted Answer · 2009-08-25T20:55:29-0400

Answer 1 / 1

venkat1926

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

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

Excel If Then Statement Maximum [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!