Who knows Google sheets?

[MrCurry]

Aarrghhh! This is driving me crazy. I’m trying to do something so simple, but I can’t make it work.

I just want to add together two numbers (130,000 and 25,400) and divide the result by 1.4 in a single cell. I’ve written it in ways which make sense to me as a long time excel user, and that doesn’t work. I’ve tried to use the DIVIDE function and that’s not working either. I’ve tried adding the two numbers and entering that as a single number and that hasn’t helped - all I ever get is “formula parse error”

Please someone save me from my unfamiliarity with Gsheets and tell me how this should be written?

 

[Throbbing Angel]

I've just tried both methods on Sheets and they worked.

The only thing I have done differently is I have inserted a space after the semi-colon in the DIVIDE calculation - I notice you don't have a space in yours - dunno if that's what's causing the issue at your end - worth trying it, though, 'eh?


Are your cells formatted as something odd/other than what they are when you open a new sheet up?

 

[MrCurry]

I've just tried both methods on Sheets and they worked.

The only thing I have done differently is I have inserted a space after the semi-colon in the DIVIDE calculation - I notice you don't have a space in yours - dunno if that's what's causing the issue at your end - worth trying it, though, 'eh?


Are your cells formatted as something odd/other than what they are when you open a new sheet up?

I did try with a space and that didn’t help. It’s most likely there is some conditional formatting which is locking down the cells. I’ll have to ask the guy who created the sheet. Thanks for answering!

 

[what]

I think there's a free version of excel online if you're more familiar with that

 

[Throbbing Angel]

I think there's a free version of excel online if you're more familiar with that

yeah, via Office.com

requires an account as Sheets does

 

[Throbbing Angel]

I did try with a space and that didn’t help. It’s most likely there is some conditional formatting which is locking down the cells. I’ll have to ask the guy who created the sheet. Thanks for answering!

Both methods gave me the correct result so that leads me to think that it is probably formatting related, too.

Can you do that calculation on a new tab (without the formatting) and =that cell in the sheet you showed us? Might work.

 

[tommers]

Why aren't you just doing a/b?

=155400/1.4

You don't need brackets.

 

[tommers]

Is the cell format set to something that it shouldn't be?

 

[tommers]

Oh this has all already been said.

I didn't even know there was a Divide function. Why would anybody ever use that?

 

[MrCurry]

Both methods gave me the correct result so that leads me to think that it is probably formatting related, too.

Can you do that calculation on a new tab (without the formatting) and =that cell in the sheet you showed us? Might work.

It throws an error even on a new sheet. I’ll send below shot to the creator of the spreadsheet and ask him what’s up

 

[Throbbing Angel]

It throws an error even on a new sheet. I’ll send below shot to the creator of the spreadsheet and ask him what’s up

View attachment 382812

 

[kalmatthew]

It throws an error even on a new sheet. I’ll send below shot to the creator of the spreadsheet and ask him what’s up

View attachment 382812

Can you try with 1,4? If that works then it could be somehow set to European localisation causing issues

 

[tommers]

Can you try with 1,4? If that works then it could be somehow set to European localisation causing issues

Nice.

 

[MrCurry]

Can you try with 1,4? If that works then it could be somehow set to European localisation causing issues

That could indeed be it! I’ll give it a go later and report back.

 

[MrCurry]

Can you try with 1,4? If that works then it could be somehow set to European localisation causing issues

This was indeed the solution. Working now

It might have taken me ages to solve that one, so I‘m much obliged!

 

[kalmatthew]

I've been bitten by it before! Gald I could help

 

[Throbbing Angel]

fyi anyone who is interested in Google Sheets

Free ebook at the moment:

Mastering Google Sheets: A Step-by-Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential eBook : Pascall, Robert G.: Amazon.co.uk: Kindle Store

Mastering Google Sheets: A Step-by-Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential eBook : Pascall, Robert G.: Amazon.co.uk: Kindle Store

amzn.eu

 

[A380]

fyi anyone who is interested in Google Sheets

Free ebook at the moment:

Mastering Google Sheets: A Step-by-Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential eBook : Pascall, Robert G.: Amazon.co.uk: Kindle Store

Mastering Google Sheets: A Step-by-Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential eBook : Pascall, Robert G.: Amazon.co.uk: Kindle Store

amzn.eu

Just downloaded this. Ta!

 

[teuchter]

I have two Google Sheets questions. This is basic stuff I think but I am no spreadsheet expert and I expect I could work it out but have to try and sort something in a bit of a hurry.

1. I have a column G of values, and I want to make a new column H that shows these values multiplied by a certain factor (let's say 2). So I can type =G2*2 in cell H2; this gives me what I want in H2 and then Google Sheets prompts to ask me whether I want to auto-fill all the cells further down column. I can answer yes to that, and I get what I want, but if I later add another row, let's say row 99 at the bottom, I don't think that H99 is going to automatically fill with the formula =G99*2. Is there a way I can set it up so that however many extra rows get added to the bottom, column H will always use that formula to multiply from column G?

2. Columns A, B and C each can have values of 0, 1, 2 or 3 in their cells. I want to make a column D that fills with something like "TRUE" if 2 or more of the cells in columns A, B and C have a value of 2 or higher.
So lets say it's row 5:
If A5=2, B5=2, C5=1 then D5=TRUE
If A5=3, B5=1, C5=1 then D5=FALSE
If A5=3, B5=2, C5=0 then D5=TRUE
etc
What formula can do this for me?