| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What if I want the answer to be in Dollars or Percentage.
I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is in dollars. If they choose 4 or 5, I want the answer to be in percentage. What do I have to add in the formula if the answer has to be in Percentage or in Dollars. Rahim Jaffer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Threaded Mode
