Stupid Excel question

[marine1]

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

 

[Affieplaas]

+120000*0.15 and hit enter

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

+120000*1.15 and hit enter

 

[3WA]

=120000*1.15

 

[Pegging]

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

 

[The_MAC]

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

 

[Smokey888]

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

This is a chat GPT question

 

[gotaway]

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

 

[Rickster]

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

 

[UB40]

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

 

[Hemi300c]

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

R100 000 x 3% = R3000 but the minimum allowed is R5000

 

[TribbleZA]

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.

 

[marine1]

=120000*1.15

doesnt work i trtied that initially and thought i did something wrong

 

[Jan van Riebeeckstad]

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

 

[marine1]

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

Really ? Thanks I would never have guessed

 

[marine1]

Alt F4

why didnt i think of that?

 

[marine1]

=120000*1.15

 

[TribbleZA]

View attachment 1697303

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

 

[Jan van Riebeeckstad]

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

You think @marine1 can do that? If he can't multiply?

 

[backstreetboy]

View attachment 1697303

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

 

[RedViking]

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