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
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
Welcome to the forum.
What is in those cells? We cannot possibly help you without knowing.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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.
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)
Bookmarks