Home 
Search 
Today's Posts 
#1




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




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




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




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 
Display Modes  


Similar Threads  
Thread  Forum  
Excel 2002 Formula: Urgent Conditional Formula Required Right Away  if possible  Excel Discussion (Misc queries)  
Build excel formula using field values as text in the formula  Excel Worksheet Functions  
match formula  2 excel files:#1 hasthis formula, 2nd has the Raw  Excel Worksheet Functions  
Excel 2002 formula displayed not value formula option not checked  Excel Worksheet Functions  
Converting an Excel formula to an Access query formula  Excel Discussion (Misc queries) 