SOLVED

EXEL CALCULATION

Copper Contributor

Hi, I'm looking for some help if it is possible to do a calculation like I do on my calculator, but if quicker on here,

for example: 0.50 + 20% x 1.25 + 50% + 11.4% = 1.25

 

Like that, so if I just put in 0.50 in and will calculate to 1.25 straight away if possible?

 

Thank you

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@JordanAtk 

Hi Jordan, assuming you write your value 0.5 in cell A1, you will get your desired result with the following formula.

=A1*1.2*1.25*1.5*1.114


I hope this has helped you now. Otherwise, please answer again and describe more precisely what you want to achieve.

it worked !Thanks very much for your help 

regards 

Jordan 

@dscheikey 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@JordanAtk 

Hi Jordan, assuming you write your value 0.5 in cell A1, you will get your desired result with the following formula.

=A1*1.2*1.25*1.5*1.114


I hope this has helped you now. Otherwise, please answer again and describe more precisely what you want to achieve.

View solution in original post