Microsoft Office Forums Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-12-2017, 01:13 PM
 Gwilson Windows 10 Office 2016 Novice Join Date: Jan 2017 Posts: 2
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.
Attached Files
 Copy of Copy of April_testInvoice-1.xlsx (26.7 KB, 6 views)
#2
04-12-2017, 04:27 PM
 Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 355

Paste in AG9, then copy down the column as required.

Code:
=IF(AB9="y","",IF(AC9="n",Y9,""))
This presumes either AB9 or AC9 will have a value, but not both at the same time.
#3
04-13-2017, 11:24 AM
 Gwilson Windows 10 Office 2016 Novice Join Date: Jan 2017 Posts: 2

Beautiful, professionally elegant, expertly stated, thank you for taking the time to share your professional experiences with me in this personal matter.
#4
04-13-2017, 11:31 AM
 Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 355

Awww ... geez .... twasnt nothin '

Glad to help. Keeps my retirement interesting !

Cheers

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post MWATKINS7111 Excel 3 02-24-2017 12:58 AM dave1510 Excel 0 05-11-2016 12:31 PM maccapacca Project 1 08-29-2013 04:55 AM borntorun75 Mail Merge 3 12-16-2011 06:28 AM peterseaford Word 2 05-23-2010 02:26 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:23 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top