View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] persspolice@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to implement subtraction from a range

Greetings-
I am trying to subtract x-i. Both variables have values between 1-26. I want for the result to always be positive; i.e. if i is bigger than x, then the difference to be subtracted from 26. For example x=3, i=10 x-i=19. Can I do this with the formulas or should I write a vb script? I am new to vb, any help is greatly appreciated.
Sean