IF Function

[mctighe]

I am trying to create a function that delivers the following:

If the value in A1 is less than 0, then I want to cell the return the inverse of A1 but if the the value is less than -250 than I want to return 250. In other words any value between 0 and -250 will return the inverse of that value but any value less than -250 (-500 for example) will return a value of 250. I've tried multiple IF OR and AND Functions but can't quite get it to work quite right. Thanks for any help!

[Kaper]

you have not specified what if a1 >0

but this is what you asked for

Please Login or Register  to view this content.

so if A1>=0 then just A1 it will become:

Please Login or Register  to view this content.

[mctighe]

Sorry, if A1>0 then return 0

[Kaper]

I hope you did it (as marking as SOLVED suggests), but just in case:

Please Login or Register  to view this content.