Stupid Excel question

[UB40]

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

In the old days RPM handed out prizes for the experts that helped day to day. Nothing anymore

 

[RedViking]

In the old days RPM handed out prizes for the experts that helped day to day. Nothing anymore

We still get prizes??

 

[marine1]

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

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

yeah because thats the problem I am having, clearly comprehension is lacking

 

[marine1]

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 are a freaking genius, thank you sir, that was the issue
Was driving me mad

Thank you once again for your help

 

[Avbob se stoep]

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

Damn thought this was my time to shine

 

[porchrat]

Doesn't really matter what you do. Excel will undoubtedly interpret the cell as a date and fsck up the display anyway.

 

[RedViking]

You are a freaking genius, thank you sir, that was the issue
Was driving me mad

Thank you once again for your help

Sir @TribbleZA . It has a ring to it.

 

[Corelli]

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

Funny its an excel question. My meeting room was once used to train graduates how to work out percentages in excel. I was sitting in the waiting space having lunch looking at this going on and wondering WTF did they learn in university.

 

[Corelli]

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

Thats probably your pirated version of excel. Excel works really well if you know how to use it. You can use column b to put in the percentages and reflect the answer in column c.

Especially if you want to work out how fast you are paying off a loan as well. By my guess is this is what he is trying to work out.

Copilot is now able to do it more accurately after we patched it. Just ask copilot, including when is the cheapest time to fly where. It will actually give you ticket prices with planes etc too now.

 

[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

Can shorten B5 formula somewhat: =B2*(B3+ABS(B4))

 

[HAL 9000]

In both Windows 10 & Windows 11, there is an error in the display of the decimal symbol when the Region setting is set to English (South Africa), as it is set to display a COMMA instead of a FULL STOP, which then also throws out the importing of CSV (Comma Separated Values) files as well.

First, close ALL MS Office apps (Word, Excel, Outlook, etc).

Then, to correct it, use Windows Search to find & then open Control Panel, set the 'View by' option on the top right to 'Large icons', then open Region:



Click on the 'Additional settings...' button, which will take you to the 'Customise Format' dialog box:

On the Numbers tab, change the settings as follows:



Then click on the Currency tab and change these settings as follows:



Then click on the Time tab and make sure the settings are as follows:



Lastly, click on the Date tab and make sure the settings are as follows:



Then click Apply & then OK - which will return you to the main Region settings dialog box - Click OK again, then close the Control Panel window.

Now you can open Excel again and your currency values will display correctly with a FULL STOP as the decimal symbol, when you select any values & apply the CURRENCY, ACCOUNTING or COMMA formatting options in the Number group on the Home ribbon tab.

 

[marine1]

This has been bloody bogthering me for weeks,

In both Windows 10 & Windows 11, there is an error in the display of the decimal symbol when the Region setting is set to English (South Africa), as it is set to display a COMMA instead of a FULL STOP, which then also throws out the importing of CSV (Comma Separated Values) files as well.

First, close ALL MS Office apps (Word, Excel, Outlook, etc).

Then, to correct it, use Windows Search to find & then open Control Panel, set the 'View by' option on the top right to 'Large icons', then open Region:

View attachment 1697417

Click on the 'Additional settings...' button, which will take you to the 'Customise Format' dialog box:

On the Numbers tab, change the settings as follows:

View attachment 1697421

Then click on the Currency tab and change these settings as follows:

View attachment 1697435

Then click on the Time tab and make sure the settings are as follows:

View attachment 1697441

Lastly, click on the Date tab and make sure the settings are as follows:

View attachment 1697443

Then click Apply & then OK - which will return you to the main Region settings dialog box - Click OK again, then close the Control Panel window.

Now you can open Excel again and your currency values will display correctly with a FULL STOP as the decimal symbol, when you select any values & apply the CURRENCY, ACCOUNTING or COMMA formatting options in the Number group on the Home ribbon tab.

View attachment 1697457

View attachment 1697459

Brilliant thanks

 

[Rickster]

@marine1

Looks like you don't know the basic formulas.

Use the =sum formula.

You can either type in a simple formula such as =sum(120000*1.15) or it could be +,- or / depending what you doing.

Or a more complex formula such as adding multiple cells together.

Ideally you would have something like this:

 

[neoprema]

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

ChatGPT

 

[marine1]

@marine1

Looks like you don't know the basic formulas.

Use the =sum formula.

You can either type in a simple formula such as =sum(120000*1.15) or it could be +,- or / depending what you doing.

Or a more complex formula such as adding multiple cells together.

Ideally you would have something like this:

View attachment 1697569

Did you bother to read anything I posted ?
I was nothing to do with the formula it was the issue with comma / full stop in region settings

 

[gotaway]

for those who are not up to asking ChatGPT, but still curious:

 

[Smokey888]

Funny its an excel question. My meeting room was once used to train graduates how to work out percentages in excel. I was sitting in the waiting space having lunch looking at this going on and wondering WTF did they learn in university.

Exactly where you can score points - solve the answer in front of everyone

 

[lkpat]

for those who are not up to asking ChatGPT, but still curious:
View attachment 1697595

View attachment 1697597

Classic example of how ChatGPT is not yet up to scratch with understanding language. You'd have to rephrase it to get the right answer.
The simplest way to ask the q is "What Excel formula would I need to use to add 15% to 120000?"

The answer is a little more complex that it needs to be, but it's correct:

= 120000 + (120000 * 0.15)