Remember Me?

 GeneI external usenet poster First recorded activity by ExcelBanter: Jan 2010 Posts: 2 Excel IF Formula

I have a spreadsheet with 4 cells that 1 of the 4 will have a calculated
value in it. I want to take the numeric value in the cell that has a value
and place it into another cell for information. Following is the string I
have written but I am doing something wrong.

=IF(E251, E25,IF(E271, E27, If(E291, E29,IF(E311, E31)))),"ERROR"

Any help would be greatly appreciated.
--
Thanks
GeneI

 ××××× (×××§×) ××××× external usenet poster First recorded activity by ExcelBanter: Dec 2009 Posts: 561 Excel IF Formula

=IF(E251,E25,IF(E271,E27,IF(E291,E29,IF(E311,E 31,"ERROR"))))
Micky

"GeneI" wrote:

I have a spreadsheet with 4 cells that 1 of the 4 will have a calculated
value in it. I want to take the numeric value in the cell that has a value
and place it into another cell for information. Following is the string I
have written but I am doing something wrong.

=IF(E251, E25,IF(E271, E27, If(E291, E29,IF(E311, E31)))),"ERROR"

Any help would be greatly appreciated.
--
Thanks
GeneI

 Rick Rothstein external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 5,934 Excel IF Formula

If only one of those cells will have a value in it and the rest are
guaranteed to be empty, then you can use this formula to do what you want..

=--(E25&E27&E29&E31)

The formula will generate a #VALUE! error if all of the cells are empty. If
that error message is not sufficient, then you can use this formula

=IF(E25&E27&E29&E31="","ERROR",--(E25&E27&E29&E31))

--
Rick (MVP - Excel)

"GeneI" wrote in message
...
I have a spreadsheet with 4 cells that 1 of the 4 will have a calculated
value in it. I want to take the numeric value in the cell that has a value
and place it into another cell for information. Following is the string I
have written but I am doing something wrong.

=IF(E251, E25,IF(E271, E27, If(E291, E29,IF(E311, E31)))),"ERROR"

Any help would be greatly appreciated.
--
Thanks
GeneI

 GeneI external usenet poster First recorded activity by ExcelBanter: Jan 2010 Posts: 2 Excel IF Formula

Your suggestion worked. Should have posted question many hours before.
Thank you very much.
Happy New Year.

--
Thanks
GeneI

"Rick Rothstein" wrote:

If only one of those cells will have a value in it and the rest are
guaranteed to be empty, then you can use this formula to do what you want..

=--(E25&E27&E29&E31)

The formula will generate a #VALUE! error if all of the cells are empty. If
that error message is not sufficient, then you can use this formula

=IF(E25&E27&E29&E31="","ERROR",--(E25&E27&E29&E31))

--
Rick (MVP - Excel)

"GeneI" wrote in message
...
I have a spreadsheet with 4 cells that 1 of the 4 will have a calculated
value in it. I want to take the numeric value in the cell that has a value
and place it into another cell for information. Following is the string I
have written but I am doing something wrong.

=IF(E251, E25,IF(E271, E27, If(E291, E29,IF(E311, E31)))),"ERROR"

Any help would be greatly appreciated.
--
Thanks
GeneI

.

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM DS Excel Worksheet Functions 4 October 7th 06 12:25 AM Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM

All times are GMT +1. The time now is 04:55 PM. Copyright ©2004-2020 ExcelBanter.