Hi,
is there a way to ignore text in a formula
=IF(F22="","",SUM(G22-H22))
G22 on this formula is set to "Not Set" as there is no number to calculate
Could the calculation be "tricked" into thinking it actually is a 0 and therefore calculate as required?
Many Thanks
is there a way to ignore text in a formula
=IF(F22="","",SUM(G22-H22))
G22 on this formula is set to "Not Set" as there is no number to calculate
Could the calculation be "tricked" into thinking it actually is a 0 and therefore calculate as required?
Many Thanks