Using "If" formula sometimes returns blank cells
I'm a student using JMP for my first time, so apologies for any wrong terminology.
I'm using this formula to assign a code to different spending ranges for RFM analysis.
The problem I'm encountering is with the top value 259.85. It sometimes returns the correct code "5" and other times returns a blank cell. Can anybody help me clear this up? Thanks for any input!
david_w_westall