If formula withy conditions

[still learning]

Hi,
I'm having a mind freeze.
How do I change the following formula so that if R7 is empty, the cell stays empty. It comes up with a 0 if R7 is empty

=IF(C7="","",IF(H7="peg",+R7,IF(R7="","")))

What I want is if C7 is empty, then the cell that the formula is in stays empty
If C7 is not empty, and H7 has peg in it, copy R7, if H7 is blank or has something else in it, then the cell that the formula is in stays empty
If R7 is blank then the cell that the formula is in stays empty even if the other two cells are not empty


Mike

 

[Akashwani]

Hi Mike.

Is this it?....

=IF(R7="","",IF(C7="","",IF(H7="peg",R7,"")))

Ak

 

[still learning]

Hi AK
Yep, It works perfect !

I didn't think to change the order

Thanks


Mike