If a cell has a value, make another cell indicate the number 1.

Solved/Closed
Raeneuf - Updated on Feb 27, 2021 at 12:39 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 27, 2021 at 04:15 PM
Hello,
If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific number.



System Configuration: Android / Chrome 88.0.4324.181
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 27, 2021 at 04:15 PM
Raeneuf, Good morning.

You can use an IF function.

Suppose:

F9 = Any data Ex.: 20

G9 = IF( F9 > 10; 1; any number/word you want)

Is this what you need?

Hope it helps.
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1