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.
|