May 17 2021 01:05 PM
Hi there!
I'm a novice, so bear with me. Numbered items below in green are working just fine, items in red are what I'm having issues with:
My sheet is heavily involved with conditional formatting, so I've attached that picture as well just in case it has anything to do with that.
However, I'm thinking this is something simple with Number Formatting>Date and seeing that the sample reads as "1/0/1900".
Any help is greatly appreciated!
May 17 2021 01:10 PM
SolutionIn L5: =IF(COUNTA(M5:N5)<2,"",N5-M5)
In J5: =IF(COUNTA(K5,N5:M5)<3,"",N5-M5-K5)
Fill down.
May 17 2021 01:21 PM
Jan 30 2023 02:59 AM
Hi, You can change the format of the cells by going to Format Cells > Customs and adding following
[=0] ;dd-mm-yyyy
This will display a blank wherever the result is 0
May 17 2021 01:10 PM
SolutionIn L5: =IF(COUNTA(M5:N5)<2,"",N5-M5)
In J5: =IF(COUNTA(K5,N5:M5)<3,"",N5-M5-K5)
Fill down.