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
Hello,

I have a spreadsheet that shows how many days a requisition has been open. I would like the words GREEN, YELLOW, and RED to show up in a cell if the req has been open a certain number of days and have no idea how to write that formula out.

So if the req is open less than 30 days then the word GREEN would show up in the cell next to it. If it is open more than 30 days and less than 60 days then YELLOW would show up, and if it is open more than 60 days then RED shows up in the cell next to the number days.

Any help will greatly be appreciated!!

Thank you!

Randy

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
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.
0