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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021  Aug 25, 2009 at 08:55 PM
Related:
 Excel If Then Statement Maximum
 Fenix internet on bank statement  Guide
 Excel if statement  Guide
 Qbittorrent maximum active downloads  Guide
 An if statement nested within another if statement will produce how many possible results?  Guide
 Excel date format dd.mm.yyyy  Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 25, 2009 at 08:55 PM
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.
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.