I am trying to create a formula for rent purposes of a hotel.
I want the formula to add 7 days to the date for every $75, add 14 days for
$150 etc.
I know the basic formula eg =A4+7*(B4=75)
But how do I make add the others also without multiplying the first ones?
If I type in =A4+7*(B4=75) then try to type in the rest A4+14*(B4=150)
It will only give me the true result of the last one and multiply the first
HELP Please???