Need help to create a formula that will, first multiply the value of two cells, then divide by 3600 & multiply the answer by a certain percentage depending on which range the answer falls into. eg.
If 2100 (A1) x 210 (B2) divided by 3600 falls between 1200 & 1400 then multiply by 110%, if answer falls between 1000 & 1200 then multiply by 112%, if answer falls between 900 & 1000 then multiply by 114%.
Thank you in advance for any assistance.
Bookmarks