LinkBack URL
About LinkBacks
Hi gurus,
I seem having an issue finding a formula based on the day of the week.
Mon to Fri rate: 850
Sat rate: 1275
Sun rate: 1700
=IF(WEEKDAY($B2)=6,$D2*1275),IF(WEEKDAY($B2)=7,$D2*1700),$D2*850)
Thank you
dude6571
Hi gurus,
I seem having an issue finding a formula based on the day of the week.
Mon to Fri rate: 850
Sat rate: 1275
Sun rate: 1700
=IF(WEEKDAY($B2)=6,$D2*1275),IF(WEEKDAY($B2)=7,$D2*1700),$D2*850)
Thank you
dude6571
How about...
=CHOOSE(MATCH(WEEKDAY(B2),{1,2,3,4,5,6,7},0),1700,850,850,850,850,850,1275)*D2
HTH
Regards, Jeff
Maybe this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks