formula

[Guest]

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

 

[y_not]

=if(j48<25,"",if(j48>25,j48+i48))

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[David McRitchie]

Hi Colin,

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

or since you don't say what to do if J48 = 25, perhaps

K48: =IF(J48<25,I48,IF(J48>25, J48+I48, " What to do if 25")

--

 

[Guest]

I WANTED TO DO
If J48 is less than 25 , then just put the info from cell I48 into cell K48.
But if J48 is greater than 25 then add I48 to J48 and have the result total
be placed into cell K48

 

[Guest]

THIS gives me "#VALUE" WHEN I MAKE J48 BE LESS THAN 25. IT WORKS WHEN J48 IS
GREATER THAN 25 BUT NOT WHEN J48 IS LESS THAN 25.

 

[Guest]

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

(I think the issue got confused a bit along the way)

You will still need to decided what to do if J48 = 25!

 

[Guest]

=IF(J48 = 25 or highter then add J48 to I48 and have the result be submitted
in cell K48.

 

[Guest]

Then the formula below is correct.

=IF(J48 = 25 or highter then add J48 to I48 and have the result be submitted
in cell K48.