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

Did you look up an IF statement in Excel help?

yes I di but im new to excell.

Robert

If you read the Help files, then you know that an IF statement needs a logical_test, avalue_if_trueand avalue_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.

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

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,"")

=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

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.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History