easy if statement formula

  • Thread starter Thread starter danlinksman
  • Start date Start date
D

danlinksman

I am having a brain freeze and need some help. It has been some time since I
have worked with formulas in excel. I am getting an invalid on the formula.
I have 2 identical worksheets on page one and page 2. I only want certain
data to show on page 2 however. What I want it to do is if h8 on page one is
blank or equal to 3 then leave cell c8 blank on page two, if it contains the
number 1 or 2 then fill c8 on page two with data from c8 of page one.
=IF(Sheet1!H8="","3","",Sheet1!C8)
 
H
=IF(Sheet1!H8="","",IF(Sheet1!H8=3,"",IF(Sheet1!H8=1,Sheet1!H8,IF(Sheet1!H8=2,Sheet1!H8))))

Click yes if helped
 
Yeah, this is an easy one. You supplied 4 arguments but the IF function
accepts only three: The condition (Sheet1!H8=""), the result if true ("3")
and the result if false (""). What you want is to OR the first two
arguments, like this:

=IF(OR(Sheet1!H8="",Sheet1!H8="3"),"",Sheet1!C8)
 
Back
Top