Hi All,
I have here a formula. First it will identify first if the value in cell AD =" YBTP" then it will proceed with formula, if the cell in AD2 = "YSHP" then another set of formula should be called.
I have created one but it keeps reflecting as false. Can some one help me on this?
They should be together in one formula.
here's my formula =
Please Login or Register to view this content.
and attached is the sample file.
=if(AD2="YBTB",formula1,if(AD2="YSHP",formula2,""))
is what you need; but I am a bit puzzled by what formula 1 and formula 2 are... There are a lot of IFs and ""s in there... Can you post them SEPARATELY?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glen,
I have figure out the answer. Thanks anyway!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks