Writing in a formula in a excell cell

Advent / Ert2250
June 21, 2009 at 09:08:40
Specs: Windows XP, 56
formulas.
how do i put a formula into a cell.

IF B2=Z THEN B1*15%.
HOW DO I PUT THE ABOVE FORMULA IN THE CELL


See More: Writing in a formula in a excell cell

Report •


#1
June 21, 2009 at 11:00:22
Did you look up an IF statement in Excel help?

Report •

#2
June 22, 2009 at 11:26:08
yes I di but im new to excell.
Robert

Report •

#3
June 22, 2009 at 11:42:20
If you read the Help files, then you know that an IF statement needs a logical_test, a value_if_true and a value_if_false, each separted by a comma.

IF(logical_test,value_if_true,value_if_false)

What is your logical_test?

What is your value_if_true?

What is your value_if_false?

Hint: One of them is missing from your post.

Once you have all of the pieces, I think the Excel help files are pretty clear on how to construct the formula. The Help files give numerous examples, some as simple as yours and others that are relatively complicated.

Tell us where you are having your problems and we'll see what we can offer. Try to build your formula, and if doesn't work, post it here and we'll take a look at it.


Report •

Related Solutions

#4
June 22, 2009 at 21:56:31
Thanks
I still cant get it to work,I have attatched a line of my data base below to let you see what I am trying to do.

i have 4 colums first on is price second one is blank 3rd one is vat 4th one is total.

I need a furmula,so that if i put x in the blank cell ,the vat shows up in the vat cell>
I am sure it can be done ,i have tried all senarios but im a dummy
Robert


Report •

#5
June 23, 2009 at 06:19:24
re: "I need a furmula,so that if i put x in the blank cell ,the vat shows up in the vat cell"

I have no idea what a "vat" is.

Since you don't seem to want to post any formulae that you have tried, I'll go back to your first post and show you an example of an IF statement.

You wrote:

IF B2=Z THEN B1*15%

In A1 put this formula:

=IF(B2="Z",B1*.15,"Not Z")

If there's a Z in B2, A1 will show the result of B1*.15 assuming that B1 contains a number that can be multiplied by .15. If B1 contains something that can not be multiplied by .15, then you'll get an error.

If there B2 does not contain a Z, A1 will display Not Z

If you want A1 to be blank if B2 does not contain a Z, use this:

=IF(B2="Z",B1*.15,"")


Report •

#6
June 23, 2009 at 21:14:32
=IF(J2="Z",I2*0.15,"Not Z")(J2="O",I2*0,"NOT 0")

tHANKS VERY MUCH FOR THE FORMULA IT WORKED A TREAT,i TRIED TO PUT AN EXTENTION TO IT BUT i HAVE DONE SOMETHING WRONG.The formula is above,VAT means( value added tax).
Your oatience with me has been great.
What mistake have I made in the above formula?.

Thanks again,Robert


Report •

#7
June 24, 2009 at 03:53:22
You need a Nested IF.

Once again, I have to ask:

Have you read the Excel Help files on IF?

The Remarks section talks about Nested IF's and Example 3 gives a number of examples of Nested IF's. None of the examples look like the formula you posted. I suggest that you copy the examples in the Help files into a spreadsheet and see if you can modify them to fit your needs.


Report •


Ask Question