Nov 22 2021 07:54 AM
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.
Nov 22 2021 08:06 AM
=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.