P
P
Pavel2017-09-25 15:44:14
Google Sheets
Pavel, 2017-09-25 15:44:14

Why don't Google Spreadsheets put a minus?

the forumla is banal =A1-B1
A1 = 5000
B1 = 1000
if B1-A1 (5000-1000) = 4000.
and if in B1 the number is greater than the number in A1, then it turns out for example (5000-8000) = 3000, but it should be - 3000!
WTF?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
x67, 2017-09-25
@mrusklon

Check the format
Expand the cell
Try an expression like "=-1*3000"
And screenshots in the studio.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question