# Stupid Excel question

#### marine1

##### Honorary Master
I am not expert but how does one work out the following?
What would one write it?
I want to say for example, R120000-00 x 15%
But I want it to add the percentage and give me the answer in the block

I know its stupid and I should know but I dont

Thanks

+120000*0.15 and hit enter

If you want to add 15% to 120,000, then:

+120000*1.15 and hit enter

=120000*1.15

If you want to ADD the percentage of VAT to the original amount, then it's *1.15

This is not an excel question, this is a grade 7 question

This is not an excel question, this is a grade 7 question
This is a chat GPT question

Where the value (120000) is in cell B2,
And the percentage (15%) is in cell B3,
Add cell B4 contains True / False for add to the total or not

Then cell B5 should contain formula: =b2*(b3+if(b4,1,0))

I think … typing on cell phone, away from excel

I am not expert but how does one work out the following?
What would one write it?
I want to say for example, R120000-00 x 15%
But I want it to add the percentage and give me the answer in the block

I know its stupid and I should know but I dont

Thanks

Give us a harder one next time.
@TribbleZA and I love Excel Trivia

Give us a harder one next time.
@TribbleZA and I love Excel Trivia
R100 000 x 3% = R3000 but the minimum allowed is R5000

Assume amount is in A1 and percentage is in B1
=iferror(if(A1*B1<5000,5000,A1*B1),"There is nothing to calculate")
Just incase either cell is blank or doesn't contain a value.

Note: You will never actually see the error as anything not bigger than 5000 will result in 5000. You will need to have another nested IF.

Last edited:
=120000*1.15
doesnt work i trtied that initially and thought i did something wrong

3WA
I am not expert but how does one work out the following?
What would one write it?
I want to say for example, R120000-00 x 15%
But I want it to add the percentage and give me the answer in the block

I know its stupid and I should know but I dont

Thanks

Alt F4

This is not an excel question, this is a grade 7 question
Really ? Thanks I would never have guessed

Use a comma - your regional settings are still purely South African. Edit them to use the . as a decimal or use 1,15

Use Google Sheets. Excel has more errors and popups than a porn site.

Lol, all the dummies are just too excited to be able to help out in this thread. Finally everyone knows the answer.