| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to separate a variable?
Does anyone have any suggestions on how to separate the E13 from following
formula? E14/1.15=C6+C7+ROUNDUP((B4+C8+C10)/(1-E13)/500,0)*2.5+(B4+C8+C10)/(1-E13) E13=??? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to separate a variable?
Here is an approximation for E13:
= 1 - (B4+C8+C10)*1.005 / ((E14/1.15)-C6-C7) Is that what you meant? Hope this helps. Pete On Apr 27, 4:32*pm, Eric wrote: Does anyone have any suggestions on how to separate the E13 from following formula? E14/1.15=C6+C7+ROUNDUP((B4+C8+C10)/(1-E13)/500,0)*2.5+(B4+C8+C10)/(1-E13) E13=??? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
| Open Separate Excel Files in Separate Windows | Excel Discussion (Misc queries) | |||
| Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
| Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Linear Mode
