Hi,
I have used IF functions but never combined 2 together. My problem is this:
I have Column A which is the sales target, Column B has the sales done, Column C has if 80% of the target has been reached and it displays YES or No. D is the commission to be paid.
What is i want to do is :
If B is equal to or larger than A multiply by R5 (where I have the value to be paid). The follwoing is the formula i am using - so far so good
=IF((F7 >= C7),$R$5, 0)
Now I want to add to the formula that if the target is not reached but 80% of it is reached I want to multiply by R6
How can i do this in the same cell.
Thanks
Ian
Bookmarks