need help for a formula that i cant find no where??

[fatih]

Hello everybody

I need an formula where one colum specific has to be set at 160 and if the value exceed that value it has to minus it and give me the value.

For example

ai33 has got a value of 157,5

aj33 has got a formula like this: =IF(AI33<160;AH33;0)

but what i want this formula to give me an value of 2,5 because 160-157,5

but in ah33 the Value is 6,5 and in aj33 it shows 6,5 how can i make that value to 2,5??

Thanks Fatih

[Pauleyb]

What if your value is over 160? Seems like =160-AJ33 would provide what you are looking for. If you still need the check, then =IF(AI33<160,160-AJ33).

Note: I am confused by your column and formula layout. Uploading a sample workbook with sample data and your desired results would help.

[arlu1201]

fatih,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.