# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I can't get this formula correct, can someone assist? I am trying to create a date for our posting process based on the payment terms. If a customer is paying biweekly, with a start date of 3/1/2018, etc. I want to be able to run daily what customers will need to be charged. =IF(OR(D2="MONTHLY",\$C\$6+30,")*IF(D2="WEEKLY",\$C\$6+7,"")*IF(D2="BIWEEKLY",\$C\$6+14,""""))
Solved by S. H. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/04/2018 - 03:49
Hi
Excelchat Expert 22/04/2018 - 03:49
Welcome to Got it Pro
Excelchat Expert 22/04/2018 - 03:50
Excelchat Expert 22/04/2018 - 03:50
Excelchat Expert 22/04/2018 - 03:50
so that i can build formula for you
User 22/04/2018 - 03:51
It is set up a bit different, D2 is a dropdown with MONTHLY, WEEKLY AND BIWEEKLY
Excelchat Expert 22/04/2018 - 03:51
OK
Excelchat Expert 22/04/2018 - 03:51
And what exactly is required
User 22/04/2018 - 03:53
If monthly is there, I would like it to date 30 days from C6, weekly 7 days, and biweekly 14 days. I was able to get this to work with just monthly, I will paste that example
Excelchat Expert 22/04/2018 - 03:53
ok
Excelchat Expert 22/04/2018 - 03:53
Let me build the formula
User 22/04/2018 - 03:54
Thank you ;)
Excelchat Expert 22/04/2018 - 03:54
See now
User 22/04/2018 - 03:55
That looks great! Thank you! Was I just missing one piece, or was I way off?
Excelchat Expert 22/04/2018 - 03:55
Brackets were wrongly placed in yours
Excelchat Expert 22/04/2018 - 03:56
You can caompare both the formula
Excelchat Expert 22/04/2018 - 03:56
Please do give good rating and reviews
Excelchat Expert 22/04/2018 - 03:56
It really helps
User 22/04/2018 - 03:56
Thank you so much! I will!
Excelchat Expert 22/04/2018 - 03:56
Welcome
Excelchat Expert 22/04/2018 - 03:56
Have a good day
User 22/04/2018 - 03:56
You as well!
Excelchat Expert 22/04/2018 - 03:57
You can end the session when done
Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.