Conditional formatting with 4 IF statements
Closed
cyberskatergirl
-
Sep 24, 2008 at 06:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 22, 2010 at 09:53 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 22, 2010 at 09:53 AM
Related:
- Conditional formatting if statements
- How many if statements can you nest - Guide
- If then statements in excel - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
4 responses
Access provides for conditional formatting without the messy CASE SELECT or IF-THEN statements. For an excellent review, look at https://docs.microsoft.com/en-us/previous-versions/office/developer/office-xp/aa139965(v=office.10)?redirectedfrom=MSDN
I am trying to create an If statement using a report that is showing a date as #NUM! or =Date(0,0,0). How to I write this in an if statement to have Excel recognize the date is missing
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 22, 2010 at 09:53 AM
Apr 22, 2010 at 09:53 AM
One approach can be
=if(iserror(Date(0,0,0),"",Date(0,0,0))
I dont know how u get 0,0,0 but I left them as you had,. You can replace with right values
=if(iserror(Date(0,0,0),"",Date(0,0,0))
I dont know how u get 0,0,0 but I left them as you had,. You can replace with right values
Apr 8, 2010 at 05:19 PM
=IF(COND1, what to do if COND1true, what to do if COND1 false)
in what to do part, you can add other if clause just as before
=IF(COND1, IF(Cond2, what to do Cond2 true, what to do Cond2 false), what to do if COND1 false)
and so on