Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create a if-then formula? | Excel Worksheet Functions | |||
how do I create a if-then formula? | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |