How do I set a permanent trigger for a cell in google sheets?

Satyajit Kumthekar 0
Viewed 11

Example

In this image, the live price will be increasing periodically. How do I set triggered to "yes" permanently once live price = trigger price?

google-sheets-formula google-sheets
1 Answers

use:

=IF(200>=205; "yes"; "no")

and substitute 200 & 205 with respective cells

player00
Related