#1   Report Post  
Old January 1st 10, 07:52 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 2
Default 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

  #2   Report Post  
Old January 1st 10, 08:02 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 561
Default Excel IF Formula

This is your "corrected" 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

  #3   Report Post  
Old January 1st 10, 08:39 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 5,934
Default 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
instead...

=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


  #4   Report Post  
Old January 1st 10, 07:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 2
Default 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
instead...

=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


.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Build excel formula using field values as text in the formula val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw DS Excel Worksheet Functions 4 October 7th 06 12:25 AM
Excel 2002 formula displayed not value formula option not checked Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017