Posted to microsoft.public.excel.worksheet.functions
|
|
Some more help to edit some formulas
Hi Max,
Thanks again for helping me out. The formula works after I took out the D28
from it. Other than that, it is doing what its suppose to do.
Examining the formulas you gave me before has taught me a lot on how the
logic on how they work. Thanks again.
"Max" wrote:
Think you could try this in C28:
=IF(OR(AZ28="",AB28=""),"",IF(AND(AZ28=1,AB28="A") ,"B"&D28,IF(AND(AZ28=1,OR(AB28={"T","R"})),"F"&D28 ,IF(AND(AZ28=1.1,AB28="A"),"1B"&D28,IF(AND(AZ28=1. 1,OR(AB28={"T","R"})),"1F"&D28,"")))))
I presumed that the conditional prefix (ie: B,F,1B,1F)
is to be concatenated with the string generated in D28,
and that nothing is to show in C28 if either AZ28 or AB28 is empty
It's easier/shorter to just use the ampersand operator: &
to concatenate cells or constants and cells,
instead of the longish CONCATENATE function.
(I used "&" liberally in the above, eg: ... "1F"&D28, ..)
Trust the above does it here for you. If it did help, could you kindly click
the "Yes" button at the bottom as the answer to the question: "Was this post
helpful to you?" before you post your reply to me from where you're reading
this in MS' webpage <g. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi,
I was able to figure a few of the problems I had, but now have only one
thing that I need help with.
So, if anyone is willing, please help me.
With no values inputted for this row Cell C looks like this:
XxxxxX014_xxxx_XXX
When Cell AZ is 1.0, and Cell AB has "A", beginning character in Cell C
should start with a "B".
If Cell AB has "T" or "R", then the beginning character should be an "F".
Also when Cell AZ is 1.1, and Cell AB has "A", beginning character in Cell C
should start with a "1B".
If Cell AB has "T" or "R", then its a "1F".
So for example, Cell AF is "A", Cell AZ is "1.0", then Cell C should be
"BxxxxX014_xxxx_XXX"
or
If Cell AF has "T" and Cell AZ is "1.1", then Cell C should be
"1FxxxxX014_xxxx_XXX"
Thank you.
|