How to use "if" formula for change price

Hi,

I want a formula for change Price if the date Saturday and Sunday, if weekdays the value remain same. Only change few the price of few value.

30 sheets with date n 10 cells with price
i want a formula which change the price on Saturday and Sunday only.

i have attach the workbook.

sorry for my bad English.

Thanks in advance

Hello maharaskal
Welcome to the forum.

I inserted SHeet1 at the end this will be your table for prices.

I've done sheets 29,30,31 for you. using IF and Vlookup.
Hope that Helps

Hello and welcome to the forum,

Maybe something like this:

Please Login or Register  to view this content.

You can replace the "Weekend price" and "Weekday price" with the new values or use a vlookup table.

Hope this helps.

abousetta

Just as a heads-up, in Excel the numerical values of days are as follows:

Please Login or Register  to view this content.

So Saturday and Sunday are 1 and 7 not 6 and 7. This will affect @vlady's formulas (I believe) since the current formula:

Please Login or Register  to view this content.

is checking for Friday and Saturday.

Hope this helps.

abousetta

Thank's abousetta.

@ abousetta

Please Login or Register  to view this content.

I think you didn't notice the number 2

I think this will return Monday as 1 through Sunday as 7.
If we will use number 3 - then monday is 0 and sunday is 6.

Thanks..

Hi @vlady,

You're right. I didn't notice the return_value. Thanks for pointing this out.

abousetta

Sorry about the delay.

add a "false" in the formula

Please Login or Register  to view this content.

You can reduce the formula to,

=VLOOKUP(A4,Sheet1!$A$5:$C$16,3-(WEEKDAY(E$1,2)>5),0)

Hi @maharaskal,

If you are satisfied with the responses then please mark the thread as Solved (instructiions in the forum rules). Also clicking on the scales add rep points to people who have helped you.

Good luck.

abousetta