Forum Discussion
Multiple IF function
Dears
I need your help to create an IF formula to the following table
Achieve number of collected invoices per Quarter
...
Hi Mohamed,
Better to create helper table with ranges for your commissions. It could be as a range or even better as Excel table (see on the top here)
When the formula to calculate commission will be
=LOOKUP(B10,$B$2:$B$7,$C$2:$C$7)
in first case or
=LOOKUP(E10,PerCent[Collected],PerCent[Commission])
for the table (at the bottom of the screenshot), and in attached file
Hello Sergei
thanks for your response ...but still not clear for me
could you please clarify it more
i have attached my excel file so you can test it on the way i need it to be worked
appreciate your support