Forum Discussion

gminii's avatar
gminii
Copper Contributor
Aug 19, 2019

HELP!! Please help with table formula in excel

I would really appreciate help with the following:

 

1. columnPL4: If columnPL3 is bigger than 1, then enter columnC4, otherwise leave cell empty

 

2. columnPL1: If columnM2 and/or columnM4 are PGP and If columnM1 is BR, then enter $AJ$10; If columnM2 and/or columnM4 are PGP and If columnM1 is SS, then enter $AM$10, otherwise leave cell empty 

 

 

THANK YOU! XX

excel
Formulas and Functions
office 365

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 19, 2019

    gminii

     

    Hi,

     

    In columnPL4, try this formula:

    =IF(columnPL3>1,columnC4,"")

     

    In columnPL1, try this formula:

    =IF(AND(OR(columnM2="PGP",columnM4="PGP"),columnM1="BR"),$AJ$10,
    IF(AND(OR(columnM2="PGP",columnM4="PGP"),columnM1="SS"),$AM$10,"")) 

     

    But you have to change columnPL3 and columnC4 in the first formula and columnM2, columnM4, and columnM1 in the second formula with the actual cell references that correspond to the formula in the cell.

     

    Regards

Resources