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

On Sep 25, 8:19*pm, smandula wrote:
Solution, as I pushed the enter button,

=IF(C270,C2,1)

With Thanks


It still doesn't work! I need C2 to register as a value.
If C2 is greater than 70 to register as a blank

=IF(C2<70,C2," "
Cell A1 has the variable ie 35
Cell C2has a formula =ReverseText(A1)
Cell D3 has the above formula =IF(C2<70,C2," ")
Any opinions,