Hi -- in the attached file I would like to input a date in A2 and then have the amount show up in B8, C8, D8 or E8 as appropriate. I filled it in manually now, showing that if the date in A2 is November then $180 should show up in D8 and nothing should show up in the B8, C8 or E8. I tried doing this with an If/then but got a "false" value in some of the cells. Can you help? Thanks.
Bookmarks