G
Guest
I have the following formula in cells G4 & H4
=IF((F4-E4)>=15,"Issue PP yes or no.","") In Cell G4
=IF(G4="yes",F4-E4,IF(G4="no",F4-E4, IF(F4-E4<=15, F4-E4,IF(F4-E4>=15,"Issue
Prompt Payment Letter.","")))) In Cell H4
I would like to transfer part or all of the information in row 4 to another
sheet if I type in yes to cell G4.
If I type no then do nothing.
Can anyone help.
=IF((F4-E4)>=15,"Issue PP yes or no.","") In Cell G4
=IF(G4="yes",F4-E4,IF(G4="no",F4-E4, IF(F4-E4<=15, F4-E4,IF(F4-E4>=15,"Issue
Prompt Payment Letter.","")))) In Cell H4
I would like to transfer part or all of the information in row 4 to another
sheet if I type in yes to cell G4.
If I type no then do nothing.
Can anyone help.