I need to create a formula IF with dates and 2 variables
Closed
adrianmty
-
Jul 14, 2017 at 08:18 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 15, 2017 at 08:53 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 15, 2017 at 08:53 AM
Related:
- I need to create a formula IF with dates and 2 variables
- Tentacle locker 2 - Download - Adult games
- Create skype account with gmail - Guide
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 15, 2017 at 08:53 AM
Jul 15, 2017 at 08:53 AM
adrianmty, Good morning.
Suppose:
A2 --> Cell with number
B2 --> DATE
C2 --> Result --> Formula
Try to use it:
C2 --> =IF(AND(A2>0,B2<=TODAY()-30), "SELL", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
A2 --> Cell with number
B2 --> DATE
C2 --> Result --> Formula
Try to use it:
C2 --> =IF(AND(A2>0,B2<=TODAY()-30), "SELL", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
