If Statement: want user to be able to enter text in cell if FALSE
- From: "jtfreed@xxxxxxxxxxxxxx" <jtfreed@xxxxxxxxxxxxxx>
- Date: 14 Apr 2005 07:56:25 -0700
Hi
I have the following formula in cell F16
=IF($M$1 =3, "149028","")
However, what I would really like is for the user to be able to input a
value in F16 is M1 does NOT equal 3.
Is there a way to do this. The current formula leaves F16 blank if M1
does not equal 3, but when the user types another value, the formula is
erased.
what am i missing? Many thanks
.
- Follow-Ups:
- Prev by Date: Re: Randomly selected numbers
- Next by Date: Re: How to stop "Help" accessing Office Online
- Previous by thread: Chart Base Line in Pivot table
- Next by thread: Re: If Statement: want user to be able to enter text in cell if FALSE
- Index(es):