View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cerealkiller Cerealkiller is offline
external usenet poster
 
Posts: 4
Default Excel formual IF statement Help

I am trying to make this IF statement work

=IF(A4="",0,IF((A4="F"),B4,IF((A4="D"),B4,IF((A4=" T"),B4,IF((A4="S"),C4,IF(
(A4="M"),C4,IF((A4="L"),C4,IF((A4="H"),C4,IF((A4=" G"),C4,IF((A4="C"),C4,"ERR")
)))))))