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

[Solved]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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

1 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month