Jun 25 2020 11:46 PM
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
Jun 25 2020 11:59 PM
@Twmorgs
See if you want this...
=IF(C5>0,E4-C5,IF(D5>0,E4+D5,""))
Jun 26 2020 12:46 AM
As variant perhaps
=E4-C5*(C5>0)+D5*(D5>0)