Formula to multiply values

Hello

i nedd a formula to multiply where i have the value, i will work with 2 collums.
I have attached a file to explain better because my englis is not very good


So i nedd when i put a value on the cell "E2" they will multyply by the cell "c2" but if i put the vaule on the cell "G2" to multiply by the cell "c2".
The value on the "E" cell it will be always the same (6,5)

Can anyone help me to arrange one formula to do this automatically, that dont need to change every time the formulas.

Thanks in advancedteste.xlsx

i put that formula in the exceel sheet and didnt work

where do you want your result to be..?
where should i put the formula...?


vikas

The result it should apears in the G collum. So the formula is will be on the G collum

I think there is something wrong in your question...
explain with a dummy correct answer (example) in your worksheet...

vikas

I think there is something wrong in your question...
explain with a dummy correct answer (example) in your worksheet...

vikas

Example
A B C D E F G
ARI10 WHITE 10,10€ 1 6,5 = 1X6.5X10.10 = 65.65€

ARI10 WHITE 10,10€ 6,5 3,90 = 10.10 x 3.90 = 39.39€

example.jpg

there you have the example

sorry but didnt work

I have put an image for example

HI,

try This =IF(D2>0,(E2*D2*C2),IF(F2>0,(F2*C2),""))
Punnam

Hi bro,
check the attachment for the solution..


click * to appreciate..

Did that helped bro...?

waiting for your reply...

if helped click *

it is only to multiply per 6,5 if i have a value on the collum "D" UNITS (= C2*D2*E2), if i dont have any value on the collum "D" is to multiply the collum "F" per "C"

Thanks

hi hallaw81,

Please address the name to whom are u refeering the post 17 ?

Punnam.

Have u checked mine i.e punnam .

Conditional Multiply-1.xlsI try the punnam's formula and dont work.

please see the attachement to see the example

hi sambo Kid, thank you very much for your help and to others too.

if you see the sheet that i have attached on my last post you can see if i dont put any value on the cells ( D or F ) the result is not correct. it multiply always the value on the cell C per E.
I will always put one value on the cell D or F. so if i put one value on D cell they will multiply the C * D*E or if i put a value on the F cel it only multiply per the C cell ( F*C)

Sambo KID i have already put your formula and dont work.

I´m sorry for my english but is not very good

Hi,

Do a favour plz update manually all the possible answers for sample table u have provide, so that we shall come different possible ways.


Punnam

please see the attached file.

many thanks

hi,

One more condition what should it happen if both Column D & F are blank ?

Punnam

Hi,

try this the formula is more or less same as Sambo Kid Post 27,it will return " " if Column d & F are Blank.

Punnam

Originally Posted by Punnam

hi,

One more condition what should it happen if both Column D & F are blank ?

Punnam

it will be always one value at the cell cell D or F. So i put a value on D cell or F

Then
try this
=IF(AND(D2="",F2=""),"",IF(D2>0,(C2*D2*E2),IF(F2>0,(C2*F2)," ")))

Punnam

Originally Posted by FDibbins

You seem to be contadicting yourself...


and based on your picgture, mu formula returns the same answer...
=C2*IF(G2="",E2,G2)

i have explain mysellf wrong sorry

this is what i need

The value on F cell will multiply always by the cell C only. The cell D multiply by the cell C and E always.