What wrong with IF formula

[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

 

[Mike H]

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.

 

[Eduardo]

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

 

[painter50]

Thanks Mike
It works, but without the quotation marks.
With the cuotation it give me a "Value"