# Formula Understanding on Days Left

1. ## Formula Understanding on Days Left

Hi,

Anyone could help to educate on the formula =IF(L481="","",(L481-K481))?

What is the different with L481-K481?

What I need is only balance days left.

Thanks,
Gary  Register To Reply

2. ## Re: Formula Understanding on Days Left

Welcome to the forum. What is in those cells? We cannot possibly help you without knowing.  Register To Reply

3. ## Re: Formula Understanding on Days Left

Thank you.

=IF(L481="","",(L481-K481))

Basically, I have

Cell L481 is submission date
Call K481 is log date
The sub-sequence cell is to capture in days.

What I don't understand is it can be done simple by using Cell L481-K481 but I could not understand why they have this IF formula.

Hope this clarifies.

Thanks.  Register To Reply

4. ## Re: Formula Understanding on Days Left

Well, did you try it without the IF statement? If you did, you would know why.

The IF statement says that if L481 is blank, then the formula will return blank. If it isn't blank, the formula performs the subtraction.  Register To Reply