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

Report
-
Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 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
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
142
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!