Forum Discussion
BillKing1953
Jul 08, 2024Copper Contributor
IFS
I am trying to calculate the following using IFS formula and having problems:
If N7>24 is true then "15"
If 15<N7<24 is true then "10"
if 0<N7<15 is true then "5"
if N7<0 is true then "0"
I can enter the first two logic tests with IFS as "If True" statements but after that the logic test seems to default to a "False" test and I don't get the value I am looking for