User Profile
Anna_C10
Copper Contributor
Joined Feb 01, 2022
User Widgets
Recent Discussions
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!
