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.
