Software

Ask something
Question Locked

Excel Spreadsheet Formula HELP!

0 helpful
3 replies

by alphaeba2233

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This will probaby seem like a very elementary question but I want to create a formula that will take each value i put into a cell and mulitply it by 1.175 i.e.

answer = cell X 1.175

obviously i don't know excel but it seems like the formulas you put in have to be multiplying one cell by another to get the product.

hope this makes sense! pls use simple words when replying lol.

3 replies

by dpalsen

I'm presuming you're wanting to put the value into a separate cell. Therefore, just put the formula "=*1.175" into the new cell.

by delbertpgh

If your value is in cell A2, then in the cell you want the product to appear, you would have the formula
=A2*1.175
If you had 1.175 stored in cell B1, you could have
=A2*B1

The leading equal-sign makes everything else interpreted as a formula. You can use + - / * and parentheses in conventional algebraic ways. You can also use Excel's many functions in your formula for more complicated numeric (or textual) manipulations.

This discussion is closed to new replies.