Need help with formula based on Day of Week

Copper Contributor

Hey there, I am trying to make a formula in my excel spreadsheet, so in the event that it is Monday, it will return a value based upon that day, with the rest of the days with the same. The formula I have below doesn't seem to work and I'm not sure why.

=IFS(B1=("Monday"),("63"),("Tuesday"),( "60"), ("Wednesday"),("66"),("Thursday"), ("65"),("Friday"), ("66"),("Saturday"), ("68"))

 

Thanks for any help provided.

 

2 Replies

@Galadore91 

=IFS(B1="Monday","63",

B1="Tuesday", "60",

B1= "Wednesday","66",

B1="Thursday", "65",

B1="Friday", "66",

B1="Saturday", "68")

 

This formula works in my speadsheet.