M
M
Mari Kos2021-08-05 12:37:39
Google Sheets
Mari Kos, 2021-08-05 12:37:39

How to add an "if" condition to a formula in Google Sheets?

We divide from one cell value by another, multiply by 100%, and the result appears in the third. But if there is such a value as 0, which cannot be divided by, then how to write it down so that the result is displayed, just the value from the cell that must supposedly be divided by this zero?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
O
Oleg, 2021-08-05
@Oleg_F

Use the formula =IFERROR()
610bb8d2f0dd8946495805.png

D
dollar, 2021-08-05
@dollar

=ЕСЛИ(A2=0;"Нельзя делить на ноль!";A1/A2)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question