excel formula

Associate
Joined
2 Aug 2006
Posts
1,719
Location
Liverpool
hi im not great with excel i know how to do sum formula but thats all, what i want to do is

a1+b1xc1

how do i write this as a formula with the answer in d1
 
Not sure which of these you want from what you've written. Type one of these in D1,

=(A1+B1)*C1

or

=A1+(B1*C1)

I suspect you want the first one.
 
In D1, type the following:
=A1+B1*C1

I can't remember whether Excel follows the standard order for processing multiplication/addition, so it might be worth adding in appropriate brackets, depending on whether you want to add A1 and B1 before multiplying (i.e. "=(A1+B1)*C1", without the quotes) or multiply B1 and C1 before adding A1 (i.e. "=A1+(B1*C1)", again, without quotes).

[EDIT: i.e., what he said... I'm clearly a bit slow today.]
 
Last edited:
Back
Top Bottom