mercredi 18 novembre 2020

Maintain Cell Value If Condition is True (Excel/Google Sheets)

What formula can I use to maintain a cell value (Integer) in excel if a certain condition is True?

*Example;

A6=5

A7=4

A8= A6 * A7 - which will give a value of 20 (in Cell A8) in this case*.

How can I maintain the 20 in cell A8 if the value of A6 was to be greater than 10 but allow is to change accordingly if it's less than 10?

Aucun commentaire:

Enregistrer un commentaire