# 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

2. ## Re: Formula Understanding on Days Left

Welcome to the forum.

What is in those cells? We cannot possibly help you without knowing.

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.

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1