I did try that, thanks, though.
> Subject: Re: Formula not working as expected > From: [email protected] > Date: Thu, 5 Nov 2015 19:19:20 -0500 > To: [email protected] > > Just a thought but shouldn't a4 be: > IF(A1="1", A2, A3) > > After all it does say that a1 is a string/text. > > Sent from my iPhone > > > On Nov 5, 2015, at 6:32 PM, Jason Tomforde <[email protected]> wrote: > > > > Hi... > > > > A1 string cell = 1 > > A2 numeric cell = 2 > > A3 numeric cell = 3 > > A4 formula cell = IF(A1=1,A2,A3) > > > > The result I am getting is 0. > > > > Any thoughts? > > > > Jason. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
