Multiple formulas inside a formula

[greenie]

Hiho, i need a quick solution to this if anyone can help me out here, i've been at it for hours...

I figured this part out, as i am using Office 2010, i can have multiple IF's in one formula.. So if anyone can figure out how could i make this formula work.. here's what i need

this is the result
Pc = 13,13 + 17,58 x 1,3 = 35,98 kn/m³

where 13,13 is from G18
17,58 is from G19

how could i make a formula like Pc = (G18) + (G19) x 1,3 = (G18+G19*1,3)...
I can't figure out what i'm doing wrong, where to put the "s, where with the ;s and so on..

PS
sorry if i posted this in the wrong section

[NBVC]

Where are the multiple IF's?

Depending on your regional settings, etc...

the formula above is just

= G18+G19*1,3

or

= G18+G19*1.3

[greenie]

You didn't quite understand me.. i need to pull information from the fields, AND display the end result in one same cell

here's a screen if it helps you

\1

so as you can see, i need to display the process of calculation, i don't know how to explain it better
i wanted a formula that will do exactly what i said

Pc = (G18) + (G19) x 1,3 = (G18+G19*1,3)

i just don't really know how to compile it properly
and multiple if's i mean this:
this is the way i get information in F column
=IF( C121="PK RADNIK";11; IF( C121="VK RADNIK"; 25; IF( C121="KV RADNIK"; 18; IF( C121="OPEKA"; 1,3; IF( C121="VODA"; 6; IF( C121="CEMENT"; 0,6; IF( C121="PIJESAK"; 110; IF( C121="DASKA"; 1037; IF( C121="GREDICE"; 1756; IF( C121="ŽICA PALJENA"; 6,07; IF( C121="ČAVLI"; 8,13; IF( C121="PIJAVICE"; 4,66; IF( C121="ŽICA"; 3,57; IF( C121="HIDRATIZIRANO VAPNO"; 0,677; IF( C121="BITUMEN"; 4,16; IF( C121="TER-PAPIR"; 5,53; IF( C121="DRVO"; 1,3; IF( C121="ČETKE"; 4,6; IF( C121="POCINČANA ŽICA"; 6,12; IF( C121="GRANULIRANI ŠLJUNAK"; 140; IF( C121="DRVO OGRJEVNO"; 1,3; IF( C121="ČAVLI"; 8,13; IF( C121="ARMATURA"; 4,33; "" )))))))))))))))))))))))

[ConneXionLost]

Can't seem to get the "m' cubed as text, but here's the first part:

Please Login or Register  to view this content.

Cheers,

[greenie]

Can't seem to get the "m' cubed as text, but here's the first part:

Please Login or Register  to view this content.

Cheers,

Please Login or Register  to view this content.

that worked perfectly!

thank you very very very much <3