Need help with Excel

Copper Contributor

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??

2 Replies

Hi Christian,

 

Could be like

=IF(OR(D578<=B578,C578=0),"YES","NO")
Hi Sergei Many thanks for your help it was spot on. Cheers Chris