Basic Excel Formulas
Budget: £10 – £20 GBP
the following cells in the main cost sheet tab require the following simple formulas entering.
Cell U17 - If formula (if cell G17 shows "yes" it will return value in cell W18, if cell G20 shows "No" the reurned value is 0
Cell U20 - If formula (if cell G20 shows "yes" it will return value in cell W21, if cell G20 shows "No" the reurned value is 0
Cell U82 - vlookup (depending on the value in cell Q83, vlookup should look at table on costings tab L2:M15, it should look in column L to see the closest number rounding up, then when found returns the corrsponding value in column M
Cell U85 - If formula (if cell i85 shows "upfront" it will return value in cell Y85, if cell i85 shows "spread" the reurned value is 0
Cell U86 - If formula (if cell i85 shows "spread" it will return value in cell Y86, if cell i85 shows "upfront" the reurned value is 0
Cell U17 - If formula (if cell G17 shows "yes" it will return value in cell W18, if cell G20 shows "No" the reurned value is 0
Cell U20 - If formula (if cell G20 shows "yes" it will return value in cell W21, if cell G20 shows "No" the reurned value is 0
Cell U82 - vlookup (depending on the value in cell Q83, vlookup should look at table on costings tab L2:M15, it should look in column L to see the closest number rounding up, then when found returns the corrsponding value in column M
Cell U85 - If formula (if cell i85 shows "upfront" it will return value in cell Y85, if cell i85 shows "spread" the reurned value is 0
Cell U86 - If formula (if cell i85 shows "spread" it will return value in cell Y86, if cell i85 shows "upfront" the reurned value is 0