Thread: IF Statements
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You can't do that with a formula, but you can with VBA. Any use?

--
HTH

Bob Phillips

"Rick Scott via OfficeKB.com" wrote in message
...
I hope someone can give a direction with this problem, even though it may

be
rather simple I just can't get my mind around it. I want to create a IF
Statement similar to (=if(C1750.00,goto I17). I need for the cursor to

jump
to I17 if C17 is greater than 50.00. I need for the cursor to go to this
cell so it will force people to enter an explanation in I17 to explain why
C17 is over 50.00. I know this may sound confusing, but I find it harder

to
explain than to try and figure out the formula to use to make it perform

this
function.

Thanks,
Rick Scott

--
Message posted via http://www.officekb.com