View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

That looks like the same action to me.

Where does the result go? If you want it in A2, you need code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"detlghtpd" wrote in message
...
i am trying to make a formula that says "if text in cell A1 is "apple"

then
add number in cell A3 to cell A2"

If Text in cell A1 is Orange then add number in cell A3 to Cell A2