| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multi formulas in excel
Please help, I'm trying to show margin or profit on a spread sheet the
formula I am using example: =C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but what I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives me -66.7% I need the answser to be positive, example 66.7 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum rounded values from two seperate formulas in Excel? | Excel Worksheet Functions | |||
| Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
Threaded Mode
