Help with formula

Copper Contributor

Hi,

I have a formula in a simple spreadsheet that I would like to expand on.

=IF(C5>0,E4-C5) OR (D5>0,E4+D5)

Can anyone please help me correct this formula

Thanks

2 Replies

@Twmorgs 

 

See if you want this...

 

=IF(C5>0,E4-C5,IF(D5>0,E4+D5,""))

@Twmorgs 

As variant perhaps

=E4-C5*(C5>0)+D5*(D5>0)