If a cell has a value, make another cell indicate the number 1.
Solved/Closed
Raeneuf
-
27 Feb 2021 à 11:43
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 27 Feb 2021 à 16:15
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 27 Feb 2021 à 16:15
Related:
- If a cell has a value, make another cell indicate the number 1.
- Tentacle locker 1 - Download - Adult games
- Cell phone codes - Guide
- Fnia 1 apk - Download - Adult games
- Excel cell color formula - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
27 Feb 2021 à 16:15
27 Feb 2021 à 16:15
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
