I need a formula that will do the following.
If F5 =0," "
If F5 is not null and I5 = "yes" , value from A5 should be entered
if F5 is not null and IF = "no", value from A5 should be entered.
Note: same values just different scenarios....