Stupid Excel Question

[SDogo]

Working on the draft spreadsheet and I'm trying to create a "value" column which in essence subtracts the selection value of a prospect from the rank value of the prospect.

For Example:

Mark Barron is ranked 12th, the Cowboys select him at 14. The value would be +2.

12 is the rank value, 14 is the selection value

I created the formula, that part was easy but the problem I'm having is that every cell in the "value" column before the selection value is entered shows a negative value.

Is there any way I can hide the values until data is entered into the selection field?

I have no idea if this makes any sense........lol

 

[Cajuncowboy]

Working on the draft spreadsheet and I'm trying to create a "value" column which in essence subtracts the selection value of a prospect from the rank value of the prospect.

For Example:

Mark Barron is ranked 12th, the Cowboys select him at 14. The value would be +2.

12 is the rank value, 14 is the selection value

I created the formula, that part was easy but the problem I'm having is that every cell in the "value" column before the selection value is entered shows a negative value.

Is there any way I can hide the values until data is entered into the selection field?

I have no idea if this makes any sense........lol

I can't answer your question but I want a copy of this when it's done.

 

[theogt]

Why do they show negative values?

 

[rocboy22]

use this formula for the value:

=IF(A2<=0,"", A2-B2)

where A2 is the draft spot and B2 is the grade

 

[BrAinPaiNt]

If you right click on the cell, click on format cells, in the numbers tab does it show up as general?

 

[SDogo]

use this formula for the value:

=IF(A2<=0,"", A2-B2)

where A2 is the draft spot and B2 is the grade

This is actually what I got to work: =IF(COUNT(C7,F10)<2, "", C7*F10)

I wanna try yours though because I'm anal and need to understand why. lol

 

[Denim Chicken]

Use conditional fomating to make your value cells text white or whatever matchs your background so you cant see it. Format-conditional formatting, make cell value condition less that 0 and click on the Format button and choose white or whatever for the font color.

 

[SDogo]

Why do they show negative values?

Because it's taking the selection value which is "0" until a value is entered and subtracting it from the rank value.

0- anything is negative. 0-1=-1, 0-2=-2.....so on

 

[Afigueroa22]

I can't answer your question but I want a copy of this when it's done.

Same here.

 

[SDogo]

Use conditional fomating to make your value cells text white or whatever matchs your background until data is entered. Format-conditional fromating, make cell value condition less that 0 and click on the Format button and choose white or whatever for the font color.

That was the other option. lol

 

[SDogo]

I can't answer your question but I want a copy of this when it's done.

Did you get one the first time?

 

[Denim Chicken]

That was the other option. lol

i like to keep it simple

 

[Cajuncowboy]

Did you get one the first time?

Nope.

 

[SDogo]

Nope.

PM me your email, I'll make sure you get it.

 

[Cajuncowboy]

PM me your email, I'll make sure you get it.

Thanks.

PM sent.