copy data to another cell

[bpflyr]

Here's what I would like to do:

If H1 is >0, then copy that number from H1 to P1.

Also, is there a way to do:

If H1>0 and Q1>0, then copy number from Q1 to R1.

Thank you for all your help!!

 

[babycody]

=IF(H1>0,H1,"") for the first question.
=IF(Q1>0,IF(H1>0,Q1,""),"") answer to second question.

Is this what you wanted?

 

[Russ At Index]

Hi bpflyr

Type this into P1 & modify for your
second question.

=IF(H1>0,H1,"")

This will leave your cell blank if there
is zero value in cell H1 & display the
numeric value if it is greater than zero.

Hope this helps.

Russ.

 

[bpflyr]

Awsome!! Thank you!!