Dynamic Conditional Statement
You can't build a conditional if statement like this as a string, but
you may not need to - what makes it conditional - is it (for example)
that you are moving gradually away from a given cell (at which point
OFFSET comes in handy) or is the value 30 variable - at which point,
why?
|