M
M
Mr.2020-05-31 13:58:16
Google Sheets
Mr., 2020-05-31 13:58:16

There is a formula =h1-f1 but what about the text or give priority to f1 than h1?

There are 3 columns 1 is {mm} 2 =h1-f1 3 {mm} The total for 2 columns is {mm}
It happens that 3 columns have the word {3 The column updates itself} I need the formula to give priority to words and not give an error that words cannot be used.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-11-27
@oshliaer

5fc073f883dfa237868811.png
Might fit
=IFERROR(C2-A2;E2)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question