Hi guys,
Really appreciate if someone could help me with this excel problem or at least point me to the right direction as I am not an excel expert.
Refer the image (try to attach the excel file but not working)
I need to calculate the total (big yellow box) based on the following ones the Volume, Gross amount and strike rate is entered
Gross
IF gross = or less than 35000 2% of the gross value
IF gross is between 35001 - 60000 4% of the gross value
IF gross is over 60000 6% of the gross value
Volume
IF volume = 15-19, 1% of the gross value
IF volume = 20-25, 2% of the gross value
IF volume 26 plus, 3% of the gross value
Strike rate
IF Strike rate is between 20-44.99%, 1% of the gross
IF Strike rate is between 45-59.99%, 2% of the gross
IF Strike rate is between 60-69.99%, 3% of the gross
IF Strike rate is over 70%, 4% of the gross
book.JPG
Bookmarks