=IF((C9+F9)*5<1000,(C9+F9)*5,1000)
Format as Currency.
Hope this helps
Rowan
"bb" wrote:
Hi, I'm trying to write an Excel formula in cell G9 to say the following:
If the sum of C9 and F9 times 5 is less than $1,000, show the result of C9
and F9 times 5. Otherwise, show $1,000. I know the formula below is
incorrect but I have no idea how to fix it. Also, I think I will probably
have to include something that will format the 1000 so that it will appear as
$1,000 (with the dollar sign and comma).
=IF(((C9+F9)*2)<1000,G9,1000)
Can anyone shed any light on this? Thanks in advance for any help!
|