Help with Formula, please!

[zSplash]

Okay, here's the idea behind the formula I am trying to write for cell S9:



If D9="", ""

else

if isnumeric(D9)=true, D9*f9

else

if D9="NMH" or D9="NMW" or D9="NMO" , D9

else
=""



This works, limitedly, but I don't want any text in S unless it's "NMO",
"NMW", or "NMH"

=if (D9="","", if(ISTEXT(D9)=TRUE,D9,D9*F9)



What's the deal with writing these formulas? What is the trick to them?
They are so much more difficult than writing VBA, which is rather straight
forward. (and the Help isn't!)



TIA, guys.

 

[David Benson]

Splash,

Doesn't seem like there's any real trick -- just write down what you want it
to do.


=if(d9="","",if(isnumber(d9),d9*f9,if(or(d9="NMH",d9="NMW",d9="NMO"),d9,""))
)


-- David

 

[zSplash]

David, thanks so much for your help.

I disagree with you about the "trick". Nothing intuitive or logical in the
part of the formula:
, if(or(x = "a", x = "b", x = "c"))?
Utterly incomprehensible, unless one understands the syntax, which, bless
you, you must.

Thanks again for your good help!

st.