Formula to send answer from 2 sources to one column

  • Thread starter Thread starter John Rundle
  • Start date Start date
J

John Rundle

=(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?
 
Maybe you meant to check it in this sequence
In say, K4: =IF(I4="a",J4,IF(E4="a",D4,""))

Note that the check: ="a" is not case sensitive
It's also better to return a blank: "", rather than a single space: " "
 
Back
Top