I am positive I am close with this but I am having issues putting this together.
=IF(G18=1, ROUND(H8*H18,2)*E18), IF(G18=2,ROUND(H9*H18,2)*E18), IF(G18=3, ROUND(H10*H18,2)*E18)
Basically G18 can have 1 of 3 values (1,2,3)
Depending which value is entered the value of the hourly rate that is charged to the client will change.
This formula used ROUND(H8*H18,2)*E18 represents
ROUND (HourlyRate*TotalHours,2digits)*Quantity
I feel like each instance should have a false statement but I am not sure how to write it.
Thank you
Bookmarks