Home

HELP!! Please help with table formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-810165%22%20slang%3D%22en-US%22%3EHELP!!%20Please%20help%20with%20table%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20really%20appreciate%20help%20with%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20column%3CFONT%20color%3D%22%23FF0000%22%3EPL4%3C%2FFONT%3E%3A%20If%20columnPL3%20is%20bigger%20than%201%2C%20then%20enter%20columnC4%2C%20otherwise%20leave%20cell%20empty%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20column%3CFONT%20color%3D%22%23FF0000%22%3EPL1%3C%2FFONT%3E%3A%20If%20columnM2%20and%2For%20columnM4%20are%20PGP%20and%20If%20columnM1%20is%20BR%2C%20then%20enter%26nbsp%3B%24AJ%2410%3B%20If%20columnM2%20and%2For%20columnM4%20are%20PGP%20and%20If%20columnM1%20is%20SS%2C%20then%20enter%26nbsp%3B%24AM%2410%2C%20otherwise%20leave%20cell%20empty%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127409i8841346FBD62C1BD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22screenshot.png%22%20title%3D%22screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU!%20XX%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810180%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!!%20Please%20help%20with%20table%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F386655%22%20target%3D%22_blank%22%3E%40gminii%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20columnPL4%2C%20try%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(columnPL3%26gt%3B1%2CcolumnC4%2C%22%22)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20columnPL1%2C%20try%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(AND(OR(columnM2%3D%22PGP%22%2CcolumnM4%3D%22PGP%22)%2CcolumnM1%3D%22BR%22)%2C%24AJ%2410%2C%3CBR%20%2F%3EIF(AND(OR(columnM2%3D%22PGP%22%2CcolumnM4%3D%22PGP%22)%2CcolumnM1%3D%22SS%22)%2C%24AM%2410%2C%22%22))%26nbsp%3B%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20you%20have%20to%20change%20%3CSTRONG%3EcolumnPL3%3C%2FSTRONG%3Eand%20%3CSTRONG%3EcolumnC4%3C%2FSTRONG%3Ein%20the%20first%20formula%20and%20%3CSTRONG%3EcolumnM2%3C%2FSTRONG%3E%2C%20%3CSTRONG%3EcolumnM4%3C%2FSTRONG%3E%2C%20and%20%3CSTRONG%3EcolumnM1%3C%2FSTRONG%3Ein%20the%20second%20formula%20with%20the%20actual%20cell%20references%20that%20correspond%20to%20the%20formula%20in%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810188%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!!%20Please%20help%20with%20table%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810188%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3Bit%20worked!%20%3Ayellow_heart%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E
gminii
Occasional Contributor

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 

 

screenshot.png

 

THANK YOU! XX

2 Replies

@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

Thank you so much @Haytham Amairah it worked!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies