Forum Discussion
Svein Tore Kristensen
Jan 26, 2020Copper Contributor
cell minus another cell and cell minus another cell
I have a problem Someone who can help me? In E2 i want (a2-c2) / (b2-d2) = £ / km (in case of incorrect or no data should refer to 0) See attached file Thanks for answers
PeterBartholomew1
Jan 26, 2020Silver Contributor
= IF( kmEnd>kmStart, (valueEnd-valueStart) / (kmEnd-kmStart), 0 )