If formula with not equal sign

[htoolin]

Hello ,

currently, we can use if formula, we can use it to check a certain condition by using equal.

however, if i wants to check if the condition is not equal to a certain condition, may i know how do i write it?

For example, I would like to use if to check if today is sunday to differentiate if it is working day or rest day. and following formula is not working.

if({today}<>"Sun","Working Day","Rest Day")

and i would be using And formula to check other condition and if “today” is not sunday.

[htoolin]

Hello, does anybody know how to write “not equal” inside if condition?

[daniel.pan]

You can use function weekday, combined with <> to check if a date is sunday.