Logic query with nested if / or statements and

[j9v]

Dear All

I wonder if you please help me with another quick one...

Attached is the spreadsheets with all your lovely formula's (and also lots of colour text boxes which are the instructions for my team who are going to be working with them - please ignore). Please refer to this.

The question is as follows:

On Bookings tab column N and P our accounts department will enter an amount ie 25 (which is £25 for 1 night), or 50 (which is £50 for 2 nights) or 75 (which is £75 for 3 nights), etc; this figure is applicable to when there are 2 people making a booking.

This data then collects into the Pre.Post Accom tab with the following formula:
IF(Bookings!$P6="",0,IF(Bookings!$P6>0,(Bookings!$P6/25)))

The problem now is if a single person books, we charge them 32 (which is £32 for 1 night) or 64 (which is £64 for 2 nights) etc.
At the moment, I just have the team entering it it manually to the Pre.Post Accom tab, and I figure there must be a formula for this...

Something that is divisible by 25 and 32...

Again, I don't have enough formula or logic skills to calculate what I want!

Best regards and thanks again!
Janine