formula
 

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

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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739

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

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(J4825, J48+I48, " What to do if 25")

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

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

"David McRitchie" wrote:

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(J4825, J48+I48, " What to do if 25")

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

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.

"y_not" wrote:


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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739

=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!


"Colin2u" wrote:

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.

"y_not" wrote:


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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739

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


"ellmcg" wrote:

=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!


"Colin2u" wrote:

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.

"y_not" wrote:


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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739

Then the formula below is correct.

"Colin2u" wrote:

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


"ellmcg" wrote:

=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!


"Colin2u" wrote:

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.

"y_not" wrote:


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


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739