Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2017, 01:13 PM
Gwilson Gwilson is offline Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Windows 10 Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Office 2016
Novice
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement
 
Join Date: Jan 2017
Posts: 2
Gwilson is on a distinguished road
Default 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
File Type: xlsx Copy of Copy of April_testInvoice-1.xlsx (26.7 KB, 12 views)
Reply With Quote
  #2  
Old 04-12-2017, 04:27 PM
Logit Logit is offline Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Windows 10 Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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.
Reply With Quote
  #3  
Old 04-13-2017, 11:24 AM
Gwilson Gwilson is offline Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Windows 10 Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Office 2016
Novice
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement
 
Join Date: Jan 2017
Posts: 2
Gwilson is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 04-13-2017, 11:31 AM
Logit Logit is offline Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Windows 10 Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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

Glad to help. Keeps my retirement interesting !

Cheers
Reply With Quote
Reply

Thread Tools
Display Modes


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
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement help constructing a TRAVEL jOURNAL peterseaford Word 2 05-23-2010 02:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft