Forum Discussion
Needing Formula help
Hi
I'm hoping somebody can help me with the attached spreadsheet please.
Why doesn't the formula in K6 return a number?
Many thanks
Rod
In K2:
=IF(J2="","",DAYS(J2,A2))
In L2:
=IF(J2="","",K2/7)
Select K2 and L2, then fill down.
The formula
=IF(J6="blank",K6,0)=DAYS(J6,A6)
compares IF(J6="blank",K6,0) with DAYS(J6,A6),
If they are equal, the formula will return TRUE, otherwise it will return FALSE.
Also: did you really want to check whether J6 contains the text blank? Or did you want to check whether J6 is empty?
And: IF(J6="blank",K6,0) refers to K6 itself, so if J6 does contain blank, you'll create a circular reference.
Can you explain what you wanted to accomplish?
Thanks for your help
I wanted the formula to check if J6 is empty then K6 and L6 would also be empty, then when a date was added to J6, K6 and L6 would then return the number of days and weeks respectively.
Hope that makes sense?In K2:
=IF(J2="","",DAYS(J2,A2))
In L2:
=IF(J2="","",K2/7)
Select K2 and L2, then fill down.
