E
E
enabl32018-02-20 18:01:28
Google Sheets
enabl3, 2018-02-20 18:01:28

How to define conditions for cells in Google Sheets?

Hello everyone, please tell me how to set parameters for cells in Google tables?
There are 2 cells with values ​​and they need to be compared and the result displayed in the 3rd.
If both values ​​of 2 are equal or the second is less than the first, then write 5 into the third.
And so on.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
DS28, 2018-02-20
@enabl3

This is done through functions. (you can write yourself from memory, you can add it through an insert) ( More )
For your example:
Let the data in cells a1 and b1.
In cell c1 we write: =If(a1>b1;"not 5";5)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question