How can i not copy the "0" to sheet 2?

[Bet_boy]

Hello Guys,

I have a question on transferring the odds from Betangel sheet to sheet 2.You copied 8 cells of odds to sheet 2 if the selections were 8 on Betangel sheet.But you only copied 3 cells of odds to sheet 2 if the selections were 3.Now the column in sheet 2 was like this:
3
13
8
0
0
0
0
0

My question is how can i not copy the "0" to sheet 2 and only copy the odds like this:
3
13
8

Can anyone help me?

Cheers.

[Dabbla]

=if(cell)=0,"")

E.G.
=IF(A1=0,"")

[Bet_boy]

Hello Dabbla,

Thank you for your post.Refer to your post i created the code on the sheet 2 like this:

='Bet Angel'!G15,IF('Bet Angel'!G15=0,"")

But the cell on sheet 2 displayed #VALUE! Did i do something wrong?

[Euler]

It is seeing a null cell and therefore you need to use the iferror command. Hit f1 and search the help file in Excel to learn more about this command.

[Bet_boy]

Hi Euler,

I have searched #VALUE! in Excel help.Due to i just touched the Excel first time,excuse me,there was no clue to fix the problem.Could you please point what the wrong is?

Cheers.

[Euler]

Google it instead for an example. I think it's important to learn Excel before you start using it to place bets!

[Euler]

http://office.microsoft.com/en-us/excel ... 56121.aspx

[pdupre1961]

='Bet Angel'!G15,IF('Bet Angel'!G15=0,"")

should be

=IF('Bet Angel'!G15=0,"", 'Bet Angel'!G15)

Paul

[JollyGreen]

It's been a while since I did any excel work but I think the use of the IF function requires two parts to the formula.

For example IF A1=0,"",A1+A2
That's because it performs a logical test like this -

=IF ( logical_test, value_if_true, value_if_false )

The comma is used as a separator so if the answer is 0 you will get a blank ("") or if not is will be the result of A1+A2.

Hope that helps?

EDIT: It looks like Paul and I posted at the same time!

[JollyGreen]

For future reference the #Value! error is usually the result of mixing text and numerical values and it can be a right pain in the **** especially if you have a large formula.

When you try and write a formula in excel try where possible to use the correct worksheet function.

For example,

Instead of writing =A1+A2
Use the function =sum(A1,A2)

This will help you find errors and repair them.

If A1 = Sunday and A2 = 24

=A1+A2 would return #VALUE!
=sum(A1,A2) would return 24

Obviously you need to be aware of what the formulas are returning but using the correct excel functions will mean more structure to your work.

Again, I hope that helps.

JG

[Bet_boy]

Thank you Guys.