Ranging foruma in excel

[Mark Scott]

I am looking for a function which does the following:

if value A is equal to or less than value B then return 0
if Value A greater than value B but less than value C then return the
difference C-B
if Value A greater than or equal to value C then return value C

I have tried using IF statements but they are not returning the values
correctly

Please can someone advise? using XL 2K7

Regards

Mark

 

[David Biddulph]

=IF(A1<=B1,0,IF(A1<C1,C1-B1,C1))

 

[Mark Scott]

Thanks David, making it harder than it should have been

 

[Guest]

=IF(A1<=B1,0,IF(AND(A1>B1,A1<C1),C1-B1,C1))

 

[David Biddulph]

Yes, but bear in mind that you don't need the AND(A1>B1, )
as we've already trapped the cases where A1<=B1 .

 

[JE McGimpsey]

Just another possibility:

=(C1-B1*(A1<C1))*(A1>B1)