View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default If logical statement and a function

Function as follows:

Function ReverseText(myText)
ReverseText = StrReverse(myText)
End Function

Purpose:
to change cell value 35 into cell value 53
this is not a problem.

However, I do not want to exceed 70 in this mirror image.
i.e. 19 becomes 91 which higher than 70 in cell C2

Using:
=If (C270,," ") doesn't work for me, it is not text but a value,
if I add =C2+1 which is 91 + 1 it equals 92
What am I missing?
Which Thanks