| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating formulas
I need to know how to create a formula for the following
D3 x 38.46 = 153.84 substract 153.84 from E3 (which will = 953.04) 953.04 x 20% will equal my answer Please help!!!Anyone??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating formulas
Hi,
Maybe: =(E3-(D3*38.46))*20% Cheers! Jean-Guy "dorismgreene" wrote: I need to know how to create a formula for the following D3 x 38.46 = 153.84 substract 153.84 from E3 (which will = 953.04) 953.04 x 20% will equal my answer Please help!!!Anyone??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating formulas
I need to know how to create a formula for the following
D3 x 38.46 = 153.84 substract 153.84 from E3 (which will = 953.04) 953.04 x 20% will equal my answer I think the formula should be... =0.2*(E3-D3*38.46) Rick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating formulas
Thank you so much. This formula gave me the correct answer. I hate working with formulas. You are a life-saver!! "pinmaster" wrote: Hi, Maybe: =(E3-(D3*38.46))*20% Cheers! Jean-Guy "dorismgreene" wrote: I need to know how to create a formula for the following D3 x 38.46 = 153.84 substract 153.84 from E3 (which will = 953.04) 953.04 x 20% will equal my answer Please help!!!Anyone??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Formulas | Excel Worksheet Functions | |||
| Creating formulas | Excel Worksheet Functions | |||
| creating IF formulas in excel | Excel Discussion (Misc queries) | |||
| Creating Formulas | Excel Worksheet Functions | |||
| Creating Formulas for overtime | Excel Worksheet Functions | |||
Linear Mode
