Expert Solution - Excel IF Problems

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

Welcome to Got it Pro

Excelchat Expert 22/04/2018 - 03:50

Can you paste your sample data so that i can help you better

Excelchat Expert 22/04/2018 - 03:50

Please paste the sample data

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

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

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