Forum Discussion
Solved
If Function Help
I am trying to set a value ranking based on sum values for a number of attributes. Can anyone see something wrong with my formula? =IFS(D3>=D10,"3",if(D3<D10>D11,"2"),D3<D12,"1")) its the "2...
PReagan Success!! after staring at these numbers I must have missed that. (good catch)
small tweak and it now works! =IFS(D3>=D10,3,AND(D3<D10,D3>D12),2,D3<D12,1)
Thank you very much for your help here!
PReagan thanks for your help!
The formula worked for 4 of 5 value sets! the 5th one I get the #N/A error. Not seeing how that is possible...
Some additional content:
Agent Values:
Agent 1 (D3) = 509
Agent 2 (D4) = 395
Agent 3 (D5) = 273
Agent 4 (D6) = 501
Agent 5 (D7) = 247
Threshold Values:
D10 = 385
D11 = 257
D12 = 128
If Agent Values is greater than D10 = 3
If Agent Values is less than D10 but greater than D11 = 2
If Agent Values is less than D12 = 1