function for values between

[SheerGold]

Hello,

I am looking for a function that will show in B2:
when the value in A1 is below 24, it shows the value in A1
when the value in A1 is between 24 and 48, it shows the value (A1-24)
when the value in A1 is over 48, it shows the value (A1-48)

[AliGW]

Try this:

=IF(A1<24,A1,IF(A1>48,A1-48,A1-24))

[TMS]

Try:

Please Login or Register  to view this content.

[SheerGold]

Thank you again

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

[popipipo]

Not clear what you want to see if the value is exact 24 or 48 maybe this wil work :

Please Login or Register  to view this content.

[SheerGold]

Hello, Thank you