I
I
Igor2020-07-09 18:03:00
Google Sheets
Igor, 2020-07-09 18:03:00

How to move part of a number to another cell in Google Spreadsheets?

For example, I need that after adding 100 + 100, the number 180 is always written into the cell, and the rest 20 into another.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-07-09
@invex

1) In the cell format, write "180" - this will be displayed instead of the value
2) Subtract 180 from the cell where (100 + 100) and write where the difference is needed.
Demo table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question