Nested IF Help

[statbid]

Hey everyone, I am trying to get the following Nested IF Function to work, but my brain has a hard time putting the logic together.

IF(D35<500,0,(IF((E35/F35)-1)<-.50,-.50,IF((E35/F35)-1)>.50,.50,(E35/F35)-1))

I am basically just looking to set an upper and lower bound if there are more than 500 clicks in a given cell.

Any help is appreciated.

Thank you,

Shilo

 

[FDibbins]

Your
IF(D35<500,0,(IF((E35/F35)-1)<-.50,-.50,IF((E35/F35)-1)>.50,.50,(E35/F35)-1))
slight modification...
=IF(D35<500,0,IF((E35/F35)-1<-0.5,-0.5,IF((E35/F35)-1>0.5,0.5,(E35/F35)-1)))
pretty much what you had though. What seems to be the problem with what you have?

 

[statbid]

Thank you FDibbins. I know it was sort of a lame post, but I was playing around with it for about an hour and finally my eyes crossed and I had to reach out for help. I felt I was moving in the right direction, just was having problems getting the brackets in the right place.

Thank you,

Shilo

 

[FDibbins]

That kinda sounds like you got this resolved?
If so, happy to help

 

[statbid]

Sorry, yeah, that's correct. Your "slight modification" did the trick. Thank you very much for your help.

Shilo

 

[FDibbins]

Good stuff, thanks for the feedback