Forum Discussion
Anna_C10
Feb 02, 2022Copper Contributor
Nested IF function
Hello everyone,
I am trying to create a nested IF function. Screenshot included for reference.
The Number of Days column needs to calculate the number of days in the date span in columns C and D. I used formula D3 - D3 +1, which gives me what I need. But, you can see from the screenshot that if there is no data in column C and D it returns 1, when it needs to be zero
(or preferably a blank) cell. I've tried the formula =IF(SUM(D3-C3+1)<1,H3" "), but it is returning zero because it doesn't like the circular reference.
Any advice very welcome, thanks!
3 Replies
Sort By