Hi,
I am trying to work out if the following formula could ignore a duplicate entry when returning the relevant number
=IF(G12="","",IF(S12="Monday",7.5,IF(S12="Tuesday",7.5,IF(S12="Wednesday",7.5,IF(S12="Thursday",7.5,IF(S12="Friday",7,IF(S12="Saturday",0,IF(S12="Sunday",0))))))))
if there is a duplicate entry (Which could be possible) i need the formula to return only 1 result and not 2
Is this possible?
Thanks
I am trying to work out if the following formula could ignore a duplicate entry when returning the relevant number
=IF(G12="","",IF(S12="Monday",7.5,IF(S12="Tuesday",7.5,IF(S12="Wednesday",7.5,IF(S12="Thursday",7.5,IF(S12="Friday",7,IF(S12="Saturday",0,IF(S12="Sunday",0))))))))
if there is a duplicate entry (Which could be possible) i need the formula to return only 1 result and not 2
Is this possible?
Thanks