IF formula with 3 criterias

Chaozfate

Board Regular
Joined
Mar 15, 2017
Messages
71
Hi, wish to ask if anyone could help me draft a formula for the following case:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Day[/TD]
[TD]Malaysia[/TD]
[TD]Hong Kong[/TD]
[TD]Dealing[/TD]
[TD]Valuation[/TD]
[/TR]
[TR]
[TD]1/1/19[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dealing if Friday is either Malaysia or HK Holiday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/2/19[/TD]
[TD]Friday[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dealing if Monday is either Malaysia or HK holiday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/19[/TD]
[TD]Monday[/TD]
[TD]PH[/TD]
[TD]PH[/TD]
[TD]Actual Dealing[/TD]
[TD]Actual Valuation[/TD]
[/TR]
[TR]
[TD]1/4/19[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Valuation if Monday is either Malaysia or HK holiday[/TD]
[/TR]
[TR]
[TD]1/5/19[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

For Dealing day, the actual dealing day fall on every Monday, but i would like excel to reverse to previous day if the actual dealing day fall on either Malaysia or Hong Kong Holiday (note that Malaysia and Hong Kong has different PH), and to continuously reverse a day if fall on another holiday.

For Valuation day, the actual valuation day fall on every Monday, but i would like excel to move forward to next day if the actual dealing day fall on either Malaysia or Hong Kong holiday, and to continuously move to next day if fall on another holiday.

Thanks in advance.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Chaozfate,

Please be more specific with what you need to happen with your data. Can you provide a step by step process to be more comprehensive.

Thank you.
 
Upvote 0
Chaozfate,

Please be more specific with what you need to happen with your data. Can you provide a step by step process to be more comprehensive.

Thank you.

Hi Sir,

Apologies for my limitation in expressing my questions and my needs. I am sorry for that, however, i manage to create a lengthy formula to achieve the result i am looking hence there will be no any necessary follows up required on my question above.

I thank you for everyone efforts in trying to help me, but i am fine with my data now.

Appreciated and cheers.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,279
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top