Forum Discussion
christian holden
Feb 08, 2018Copper Contributor
Need help with Excel
hi all
Small issue here can anyone help?
I have a formula here that works but want to add to it but know how
here is the formula
=IF(D578>B578,"NO","YES")
it is basically if this date is greater than this date, return a "NO" otherwise return "YES"
what I need to add is this
if C578 has £0.00 always return "YES"
can anyone help??
Hi Christian,
Could be like
=IF(OR(D578<=B578,C578=0),"YES","NO")
- christian holdenCopper ContributorHi Sergei Many thanks for your help it was spot on. Cheers Chris