If Then statement to write text in cell

I need a function to say


IF((B3>B2::THEN Write in B4"Some text")ELSE Write"Another text"))


eg

if 5 (B3) is greater than 3 (B2), write this text in B4 "Some text"

else write "Another text"



Part 2

A second action is required once the above is completed.

If A(then copy cell data from C1 into D10)(ELSE(copy cell data of D1 into D10))


eg.

IF((A is true copy the the "C1 Contents" into D10)(Else copy "D1 Contents" into D10))

MacBook Pro, Mac OS X (10.7.4), bought in 2012

Posted on Feb 1, 2013 9:35 AM

Reply
26 replies

Feb 6, 2013 2:52 AM in response to Barry

I did put numbers 08 in the tags section of the first entry...but that was soooo long back in this thread.

Well I downloaded Numbers 09 and started playing around with it

Let me see if I can figure it out from all the help you both have kindly provided.

Either way I'll get back to you both here.

Many thanks Jerry & Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

If Then statement to write text in cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.