|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement
Your assistance please, as I need an If Formula to help me to pull myself out of the following:
I think I am trying to say the following; If AB9 equals “y”, then AG9 is to list a zero or blank, but if AC9 is listing a “n” then AG9 is to equal y9 {…, y and n to stand in for yes and respectively} So far, my results from the following formulas: =(if, AB9="y", AG9=0), or (if AB9="n”, AG9=y9) =IF((AB9="y”, AG9=0), and if (AB9="n”, AG9=y9)) =IF((OR (AB9="y”, (AB9="n")), AB9=0, AB9=y9)) =IF, and ((OR (AB9="y”, (AB9="n")), AB9=0, AB9=y9)) net the following Excel warning “There’s a problem with this formula Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it’s a formula: To get around this, type an apostrophe (‘) first: You type: ‘=1+1, cell shows: =1+1” Any time and/or solutions that you are willing to share with me in this personal matter to alleviate this predicament is greatly appreciated. |
#2
|
|||
|
|||
Paste in AG9, then copy down the column as required.
Code:
=IF(AB9="y","",IF(AC9="n",Y9,"")) |
#3
|
|||
|
|||
Directional help received and your solution is Outstanding
Beautiful, professionally elegant, expertly stated, thank you for taking the time to share your professional experiences with me in this personal matter.
|
#4
|
|||
|
|||
Awww ... geez .... twasnt nothin '
Glad to help. Keeps my retirement interesting ! Cheers |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help! figuring if statement with 2 vlookups excel 2013 | MWATKINS7111 | Excel | 3 | 02-24-2017 12:58 AM |
Excel (2016) Hangs | dave1510 | Excel | 0 | 05-11-2016 12:31 PM |
Constructing a detailed Timeline | maccapacca | Project | 1 | 08-29-2013 04:55 AM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
help constructing a TRAVEL jOURNAL | peterseaford | Word | 2 | 05-23-2010 02:26 PM |