What wrong with IF formula
 

=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
--
Joe

What wrong with IF formula
 

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.


"painter50" wrote:

=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
--
Joe

What wrong with IF formula
 

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" wrote:

=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
--
Joe

What wrong with IF formula
 

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


"Mike H" wrote:

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.


"painter50" wrote:

=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
--
Joe