# Solved: two formula in single cell

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### kmkmechster

i want a single cell to contain two formulas by which i'm very confused to derive this
A(cell):1(value), B:3, result-C:3(a*b), if i again change A cell to 3 the C should come as 6, that is i dont want to multiply, instead i want to double the value of previous C result. Can someone help me?

#### Yorkshire Guy

Hi,

So you have this:
A B C (= A*B)
1 3 3

and you want this:
A B C
3 3 6

This will do it but I sure don't know why you want it.
In C put:
=If(A=1,A*B,A+B)

with row numbers of course.

#### kmkmechster

hi,

it is showing as #Name?, did i do something wrong?

#### kmkmechster

sorry, i did a mistake, it is now working, thank you very much yorkshire guy

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On