Formula

M

mark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

balance in excel that only shows the last entry 3
=IF, If only I knew the answer 4
Combining two functions 13
Remove the Formula but leave the value alone? 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
nested "if" formula problem. 5
Complex Autofill does not follow formula 4
iserror 4

Top