Excel expert wanted - formulas required
Budget: £10 – £15 GBP
Various simple formulas required for a large spreadsheet.
Eg - If cell P2 = less than 4 and Cell R2 = 1
If Cell P2 = between 5 and 7 and Cell R2 = 1 or 2
If Cell P2 = between 8 and 15 and Cell R2 = 1 2 3 or 4
Then return that value
Then I want a formula to calculate the percentage time that value happens against certain criteria.
Eg - If cell P2 = less than 4 and Cell R2 = 1
If Cell P2 = between 5 and 7 and Cell R2 = 1 or 2
If Cell P2 = between 8 and 15 and Cell R2 = 1 2 3 or 4
Then return that value
Then I want a formula to calculate the percentage time that value happens against certain criteria.