If/Then formula

[howard stovall]

How do I format the following in Excel:
Cell formula is =E33*.2; If e33*.2 < $20,000 then cell value = $20,000

Thanks.

 

[Claus Busch]

Hi Howard,

Am Wed, 02 May 2012 19:15:17 GMT schrieb howard stovall:

How do I format the following in Excel:
Cell formula is =E33*.2; If e33*.2 < $20,000 then cell value = $20,000

try:
=MAX(E33*0.2,20000)


Regards
Claus Busch

 

[joeu2004]

How do I format the following in Excel:
Cell formula is =E33*.2; If e33*.2 < $20,000 then cell value = $20,000

The better way:

=MAX(20000, E33*0.2)

But for your edification, the IF expression would be:

=IF(E33*0.2 < 20000, 20000, E33*0.2)

PS: If you prefer, E33*0.2 can also be written as E33*20%.