Hi thanks for the great plugin,
I want to replace the input of fieldname2 (if 0 => 1, if 1 => 1,2, if 2 => 1,4) and multiply it with fieldname1. Moreover fieldname 2 has a minumum of 0 and a maximum of 2)
fieldname1 * (MIN(MAX(0, (IF(fieldname2 == 0) return 1) OR (IF(fieldname2 == 1) return 1,2) OR (IF(fieldname2 == 2) return 1,4),2)))
Thank you very much,
The page I need help with: [log in to see the link]
- The topic ‘Replace Numbers with IF’ is closed to new replies.