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,
|