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 ' on keyboard - Guide
- Mutator function c++ - Guide
- Network card function - Guide
- How to remove write protection from usb - Guide
- Hard drive function - 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.