View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeneI GeneI is offline
external usenet poster
 
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