If on column B format as date
try this
![]()
=IF(MONTH(B1)>=7,IF(C1="Alan",60,IF(C1="smith",55,40)),"")
If on column B format as date
try this
![]()
=IF(MONTH(B1)>=7,IF(C1="Alan",60,IF(C1="smith",55,40)),"")
Click (*) if you received helpful response.
Regards,
David
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks