IF function for multiple cells and options
Closed
BacktotheFuture
Posts
1
Registration date
Saturday December 23, 2017
Status
Member
Last seen
December 23, 2017
-
Dec 23, 2017 at 01:34 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 25, 2017 at 07:33 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 25, 2017 at 07:33 AM
Related:
- IF function for multiple cells and options
- Netflix payment options - Guide
- Shortcut to internet options - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files at once - Guide
- Agp function - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 24, 2017 at 06:42 AM
Dec 24, 2017 at 06:42 AM
Backtothefuture, Good morning.
Please give us more information about your logic.
As you say any of the three cells can contain the IF clause, what happens if A2 <01/01/2000 and C2 is between 01/01/2000 and 12/31/2012 and E2> 12/31/2012?
What will be the response group?
We need to know how your layout is to help you faster and more conclusively.
Please give us more information about your logic.
As you say any of the three cells can contain the IF clause, what happens if A2 <01/01/2000 and C2 is between 01/01/2000 and 12/31/2012 and E2> 12/31/2012?
What will be the response group?
We need to know how your layout is to help you faster and more conclusively.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 25, 2017 at 07:33 AM
Dec 25, 2017 at 07:33 AM
backtothefuture, Great Christmas morning.
"...Is there a way to calculate this based on TODAYs date instead of having to change it manually?..."
Of course there is a way.
I made a small example for you.
https://www.sendspace.com/file/u8me3y
Please tell us if this is what you wanted.
Hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...Is there a way to calculate this based on TODAYs date instead of having to change it manually?..."
Of course there is a way.
I made a small example for you.
https://www.sendspace.com/file/u8me3y
Please tell us if this is what you wanted.
Hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Dec 24, 2017 at 01:54 PM