ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Formula (https://www.excelbanter.com/new-users-excel/9760-formula.html)

mark

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.



All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com