IFF Situation

C

caro

I am trying to write an IFf statement where if the raw data entry is less
than 1, the number 1 populates. If the raw data entry is less than 5, a 2
would appear. If the raw data is less than 9, a 3 appears. If the raw data is
less than 13, a 4 appears. And if the raw data is less than 16, a 5 appears.

My formula so far is:
IFf («Expr» [Raw Score (1-5)] < [1], [1]) IFf "([Raw Score (1-5)] < [5],
[2]) IFf ([Raw Score (1-5)] < [9], [3]) IFf ([Raw Score (1-5)] < [13], [4])
IFf ([Raw Score (1-5)] < [16], [5])

Please help!
 
P

Piet Linden

I am trying to write an IFf statement where if the raw data entry is less
than 1, the number 1 populates. If the raw data entry is less than 5, a 2
would appear. If the raw data is less than 9, a 3 appears. If the raw data is
less than 13, a 4 appears. And if the raw data is less than 16, a 5 appears.

My formula so far is:
IFf («Expr» [Raw Score (1-5)] < [1], [1]) IFf "([Raw Score (1-5)] < [5],
[2]) IFf ([Raw Score (1-5)] < [9], [3]) IFf ([Raw Score (1-5)] < [13], [4])
IFf ([Raw Score (1-5)] < [16], [5])

Please help!
Click to expand...

IIF([RawScore]<1,1,IIF([RawScore]<5,2,IIF([RawScore]<9,3,IIF([RawScore]
<13,4,IIF([RawScore]<16,5,NULL)))))
 
Top