How to write an If Function
Closed
Randy
-
Oct 22, 2009 at 10:52 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 24, 2009 at 04:29 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 24, 2009 at 04:29 PM
Related:
- How to write an If Function
- How to write & in laptop - Guide
- How to write pi on keyboard - Guide
- How to write e with accent - Guide
- How to remove write protection - Guide
- Find function on mac - Guide
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 24, 2009 at 04:29 PM
Oct 24, 2009 at 04:29 PM
assuming its just the number of days in the cell in question and not a date formula then the following formula will fit your needs.
=IF(A1<30,"green",IF(AND(A1>=30)*(A1<60),"yellow","red"))
assuming the days figure are in cell A1. amend to suit your circumstances
then copy the formula down the column in the normal way.
=IF(A1<30,"green",IF(AND(A1>=30)*(A1<60),"yellow","red"))
assuming the days figure are in cell A1. amend to suit your circumstances
then copy the formula down the column in the normal way.