Hi,
I want to assign a number in one cell based on month value in another cell e.g. if date in cell B20 is 28/04/2013 (28 th April 2013) means month is 4. If month = 4 then Cell value in F20 should contain 4 ELSE it should contain 5. I tried this formula in cell E20 like....,
=IF((MONTH(B20))=4,F20=4,F20=5)
but instead of giving desired result, it appears word FALSE in cell E20, why and how to resolve ?
Bookmarks