Forum Discussion
IF-function for date in excel, some dates becomes 0
Hi! I am doing a payable in excel for an assignment. I'm using the IF-function to calculate what the date should be in the column named date of payment. This is the function I have created: =OM(B6...
Thank you so much for your answer, and quick reply!
So basically, what I have done is that I have divided the formula into two parts?
I will try to figure it out on my own, but if you have time to help, how do I fix the problem without having to insert a second formula like OR? I think that is too advanced for me.
Regards!
Hello Akila,
You can use the IFS function to fix the problem - see below.
=IFS(B6=420,C6+$O$6,B6=500,C6+$O$7,B6=150,C6+$O$8,B6=320,C6+$O$9)
This should work fine and you do not need the second part of the formula again.
I hope this helps.