Multiple IF
Hello there once again!
does any fine individual out there how to help me with the following, I have the following in a cell,
=IFS(K81<3000,K81*0.1,K81<50000,K81*0.08,K81>=5000 0,K81*0.06)
I would like the number in the cell to display
10%, 8% or 6% depending on the value of the sum
Is this possible, I have been at this for some time and the attachments shows you all how well I have done
Thanks Jonathan
|