Quick Links

Reply To: Need help with formula

Home Forums Discussion Need help with formula Reply To: Need help with formula

Sai Prasad
  • Community Leader
  • Forum Pro

Hi Carl, It was nice speaking to you. It helped to have clarity on your requirement. Please use this formula for Number5 instead – IIf(Number4=4,4,IIf(Number3=3,3,IIf(Number2=2,2,IIf(Number1=1,1)))). Please note Number4 refers to the fourth field, and so on, and so change the field names accordingly. I tested this formula with different combination so that the highest value between Number1 to Number4 is selected in Number5 field – Here is a screenshot for that https://photos.app.goo.gl/AmTUP4uSvEjzgz6p8