Forum Discussion
How toi create formula using IFS and AND
I am trying to create a formula using IFS to check three possible outcomes: value<5000 - return RM 5000<value<30000 - return VPO value<30000 - return IPC I have managed to get the true value r...
Let's say the value is in A2. The formula (in another cell) could be
=IFS(A2<5000,"RM",A2<30000,"VPO",A2>=30000,"IPC")
or
=IF(A2<5000,"RM",IF(A2<30000,"VPO","IPC"))
or
=LOOKUP(A2,{0,5000,30000},{"RM","VPO","IPC"})