Forum Discussion

BillKing1953's avatar
BillKing1953
Copper Contributor
Jul 08, 2024

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

 

Resources