Thread: Formula
View Single Post
  #1   Report Post  
mark
 
Posts: n/a
Default Formula

Hi

I have the following formulas in cells G & H

=IF((F4-E4)=15,"Issue PP yes or no.","") In Cell G

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

If Cell G4 = Yes. Is there anyway I can then transfer
that row or certain infor from that row to a master
sheet?
If Cell G4 = No. Then do nothing.