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???

If I understand you correctly:

=A4 + 7 * INT(B4/75)

In article ,
anam_cara wrote:

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???

Hi,

I think you are looking for the following formula
=A4+(B4*7/75)
This assumes that certain number of days is already present in A4. Then
based on B4 you add 7 days for every $75.Hence if B4 is 75 then you add 7
days if it is 150 then the formua adds 14 days and so on.(It also adds
fractional days, but since your question did not specify how that has to be
taken care of, I did not provide a solution for that.)

Alok Joshi

"anam_cara" wrote:

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???