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!
Agent 5 (D7) = 247
247 is greater than 385; FALSE
247 is less than 385 but greater than 257; FALSE
247 is less than 128; FALSE
Agent 5 fails all criteria, hence returning false or "something is wrong". Perhaps you should revisit your criteria to account for this.
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!