Thread: formula
View Single Post
  #2   Report Post  
Sandy Mann
 
Posts: n/a
Default

A formula can only enter values into the cell in which it resides, it cannot
enter data into any other cells so the formula must be entered in K48.

Try:

=IF(J48<25,I48,J48+I48)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Colin2u" wrote in message
...
i am trying to do this::
=IF(J48<25,"",K48) just insert the info from I48 into K48
BUT
=IF(J4825)
then add J48 info to I48 and place the total in K48.
is this possible and how is it done