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 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 27, 2021 at 04:15 PM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 27, 2021 at 04:15 PM
Related:
- How do you tell one cell from another
- Excel multiple lines in one cell - Guide
- How to delete one cell in word - Guide
- Cell phone codes - Guide
- Clear only the formatting from the selected cell - Guide
- Excel cell color formula - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 27, 2021 at 04:15 PM
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
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
