I've asked this over at Stack Overflow (believing it to be a replacement for Experts Exchange), but it seems to be mainly for software developers:
This is probably a simple one for some you you wizz kids. I have an O365 Sharepoint Site with a form in which a school is using to collate pupil scores.
We have 3 cells which have numeric values as follows:
Column A: Number Column B: Number Column C: Number Column D: Calculated: Column C - Column A
What we need to do is to make column D display conditional data based on 2 scenarios:
If Column C has no data in it = Column B - Column A.
If Column C does have data in it = Column C - Column A
How would I write out the calculation?