ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to create this formula please (https://www.excelbanter.com/excel-discussion-misc-queries/32903-how-create-formula-please.html)

Rory

how to create this formula please
 
I need to create a formula do do the following,
take an amount in a cell and add 50.00 then *1.175 and then *0.2 and display
the total in a chosen cell.
thankyou in advance.
Rory.

Anne Troy

You've practically written it yourself. Suppose your amount is in cell A1,
then your formula would b:
=((A1+50)*1.175)*.2
Of course, it could be:
=(A1+50)*(1.175*.2)
But I think you should be able to get started.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Rory" wrote in message
...
I need to create a formula do do the following,
take an amount in a cell and add 50.00 then *1.175 and then *0.2 and

display
the total in a chosen cell.
thankyou in advance.
Rory.





All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com