Formula to calculate difference between 2 numbers

[sats43]

Hi,

I have a number 60 and i have slab 0-20 and 20-50 and 50 and above.

I would need a formula using above 60 number and should give me the result of 30 ..

which is like the part of 60 value falls between 20 to 50 slab.

Please advice

Thanks

[sats43]

Please ignore i found the logic and its straight forward with IF logic .. if the number is above 60 .. i can put the function as 50-20 and result is 30.

[Punnam]

Hi Sats43,

That's fine now mark the thread as solved using the thread tools.

Punnam