79086611

Date: 2024-10-14 14:44:41
Score: 2.5
Natty:
Report link

This formula should to the job, according to my grasp of the problem. If I misunderstood, please comment.

=ARRAYFORMULA(IF(ISBLANK(F7:F),IF(ISBLANK(G7:G),"",ROUND(($H7:H-$G7:G)*10000,2)),ROUND(($F7:F-$H7:H)*10000,2)))

Spreadsheet output

Reasons:
  • RegEx Blacklisted phrase (1): I misunderstood, please
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user27425627