All,
I have constructed an if-and statement to populate a cell based on two factors: if the month (blue) occurs after the 'eligible date' (blue) and the 'variance' (blue) is equal to or greater than zero, the 'actual bonus' (yellow) would populate with 'potential bonus' amount; as it stands, the 'actual bonus' defaults to the 'potential bonus' , and I'd like it to be empty when no data is entered. Please advise.
Thanks in advance.
Bookmarks