Try:

=ROUND(((B1-A1)/7),0)*1.75

Note that if they rent for less than 4 days it will result in zero.

If you want it to default to 1.75 if they rent for less than 4 days do
the following:

=IF(AND((B1-A1)<4,(B1-A1)=0),1.75,ROUND(((B1-A1)/7),0)*1.75)

Hope that helps.


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534975