Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Excel formula
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! |
#2
|
|||
|
|||
=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! |
#3
|
|||
|
|||
G9:
=MIN(1000,5*(C9+F9)) 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |