06-30-2020 05:51 AM
06-30-2020 06:22 AM
What you are saying would be translated into this...
But if H2 is blank or empty, do you still want to subtract G2 from H2.
In the above IF formula H2="" is the logical condition and if it is true, H2-G2 would be evaluated else it will return a null string in the formula cell.
Tweak it as per your requirement.
by DougBayless on August 05, 2020
by jongonzalez189 on August 05, 2020
by Guy Hunkin on August 05, 2020
by Sonia Atchison on July 24, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020