Excel in Windows 10

by Cora   Last Updated June 13, 2019 07:01 AM

In my target cell I want to subtract the numeric value in one cell from another cells numberic value - but if one of those two cells contains a zero value or if it contains the text "ongoing" I do not want any calculation to take place and my target cell to remain empty. Any help with a formula would be hugely appreciated.



Related Questions


Updated November 10, 2017 00:01 AM

Updated April 21, 2015 22:00 PM

Updated June 05, 2015 07:00 AM

Updated May 07, 2017 01:01 AM

Updated October 06, 2015 13:00 PM