Any Excel gurus around?

Steve · 08-29-2016, 11:32 AM

Yes, that's pretty much what I was looking for. For now I am ok with her being within 1.5 yards either direction, but as we go on, I want to be able to adjust that. I have a column set up to indicate if she is + or Minus on the distance.

I was able to get a yes/no if b=a, but couldn't quite figure out how to do in a range.

markem · 08-29-2016, 11:35 AM

Quote:

Originally Posted by Steve

Yes, that's pretty much what I was looking for. For now I am ok with her being within 1.5 yards either direction, but as we go on, I want to be able to adjust that. I have a column set up to indicate if she is + or Minus on the distance.

Here is a good source for more info on if() constructs:

https://exceljet.net/formula/nested-if-function-example

08-29-2016, 11:32 AM	#1
Steve Dad Jokester Supreme Join Date: Oct 2008 First Name: Steve Location: 17 R 435648 3354895 Posts: 7,715 Trading: (6)	Re: Any Excel gurus around? Yes, that's pretty much what I was looking for. For now I am ok with her being within 1.5 yards either direction, but as we go on, I want to be able to adjust that. I have a column set up to indicate if she is + or Minus on the distance. I was able to get a yes/no if b=a, but couldn't quite figure out how to do in a range. __________________ ...So don't sit upon the shoreline and say you're satisfied, Choose to chance the rapids and dare to dance that tide