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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 27, 2021 at 04:15 PM
Related:
- If a cell has a value, make another cell indicate the number 1.
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Fnia 1 - Download - Adult games
- Tentacle locker 1 - Download - Adult games
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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
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
