Looking to combine the following string

[rlc]

=(C18*C19)/1000, (L21*C22), (C33*C34*I23),(C35*C26)/1000, (C36*C25)


>First, is this possible?, Could you provide the proper syntax to do do.

>Could you also include an if within the section (C33*C34*I23) IF it is < 3000 then it is equal to 3000.


Thanks in advance for assistance you can provide.

 

[Faseeh]

Hi rlc,


Welcome to the forum!!


Your problem description in incomplete, sorry to say that. What do you want to do with that formula, and what you think is possible? What are criteria and what results do you need?? I think you should have a go through following link:


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

http://chandoo.org/forums/topic/posting-a-sample-workbook


Regards,

Faseeh

 

[SirJB7]

Hi, rlc!


Taking a blind shot, maybe you tried to mean this:

=(C18*C19)/1000 & "-" & (L21*C22) & "-" & (C33*C34*I23) & "-" &(C35*C26)/1000 & "-" & (C36*C25)


If so, replace "-" by the required separator. If any numeric values, maybe you'd need to embed them within TEXT(value,format) functions.


Regards!