![]() |
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. |
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