What wrong with IF formula

  • Thread starter Thread starter painter50
  • Start date Start date
P

painter50

=IF(C6=1,H6=100,P8)
What Iam trying to do is have this the total in P8 to to show in I6. Any
help is much needed. Thanks
 
Hi,

Is this what you mean

=IF(AND(C6=1,H6=100),P8,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Hi,
Not clear what you need, if C6=1 I think you want the total in H6 to be
entered in cell P8 if this is correct in P8 enter

=if(C6=1,H6)

If you want the cell to be blank if C6 <>1 use

=if(C6=1,H6,"")

If the above is not the case please post an example
 
Thanks Mike
It works, but without the quotation marks.
With the cuotation it give me a "Value"
 
Back
Top