Formulaes kicking in when certain criteria is met

Dear all

Help

I need a formulae that will kick in after various criteria is met. Rule 1: If A is met then the answer is 75, if rule B is met then the answer is 15% of cell C1 with a min of 175 and a max of 250 applying, if rule c is met then the answer os 20% of C1 with a min of 200 and a max of 250 applying.

I know the formulae =IF(C23 * 0.15 < 175, 175, IF(C23 * 0.15 > 250, 250, C23 * 0.15)), will help me if rule b was the only rule but am having trouble with the rest.

Any help would be truly appreciated!!!!!

Hi Thanks for all your help.

Im a letting agent, trying to set up a excel for the rest of the staff so that we can quote quickly and easily all of our charges so that everything is confirmed in writing quickly.

Tenant Charges
A. For rooms and bedsits with some shared facilities £75
B. For all self contained accommodation. 15% of a gross month rent + Vat with a min of £175 + Vat and a max of £250
C. In exceptional circumstances sharing maybe permitted, where there is three of more adult occupants take one tenancy. 20% of a gross month rent with a min of £200 and a max of £250.

I think that i forgot to put in the last email that i would like to use a data validation list for the A, B & C aspect, the staff select the button then the cell will work out from the info above what charge to make.

si this something that you could help with ?

Expected out puts, if rule a is met the output will be £75, if its B then it will be 15% of cell c1 which is £150 (with the rent at £1k), but then the min will applying bringing it up to £175,

and so on.....

how do i post a demo file ? and what is it ?, not a clue in the world, sorry

There isnt anything in the worksheet yet, its done in our heads which is one of the reason that I am trying to set the excel up, I'll try to explain again.

I woudl like to have a cell with a data validation list, listing A, B & C.
If my collegaue selects A, then the answer in the formaulated cell will be £75, if they select B then the answer will be 15% of the price in cell C1, but it will have a min of £175 and a max of £250 should the 15% be lower or greater, if they select C then it will be 20% of the price in cell c1 and again min of 200 and max of 250 come into play.

Hope you can help