Hi All -
I am EXTREMELY new to Excel and am having trouble with configuring what I need this job aid to do:
The attached sheet is to be used as an aid to determine pricing for a contract year with an annual percentage increase. The trick is, sometimes a particular coverage of "Cleaning" (Column C) does not receive the increase (I:1) that all the other coverage types receive.
I want users to be able to select from the drop down in (I:3) if the increase applies to the "Cleaning" coverage type but I cannot figure out how to work this or where to put any applicable formulas.
I think I need a formula in Column I that basically says the following:
IF I3 = YES, then determine the value of Column F x the increase percentage of (I:1), IF I3 = NO, then copy the annual value in Column F.
Any help or input?
Thanks in advance!
Bookmarks