View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Rundle John Rundle is offline
external usenet poster
 
Posts: 1
Default Formula to send answer from 2 sources to one column

=(IF((I4="a"),J4, " ") or IF((E4="A"),D4," "))

This is my arttempt to construct a formula fill in a table of expenses. I
know that each part of it will work separaely but this returns an answer of
#VALUE!

Can anyone tell me why?