ExcelBanter - creating formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - creating formulas (https://www.excelbanter.com/excel-discussion-misc-queries/167303-creating-formulas.html)

dorismgreene

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???

pinmaster

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???

Rick Rothstein \(MVP - VB\)

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

dorismgreene

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???

All times are GMT +1. The time now is 11:34 AM.