Assigning a single value to a column
 

I'm trying to put together a commission spreadsheet and want to assign just
one numeric value to an entire column, however, I only want the data inputted
for cells used. Ex: Column F is for protection plans sold....if "Y" is
entered then the value should equal "$5.00", if left blank then no value is
entered into the cell. Does anyone know how to acheive this?

Assigning a single value to a column
 

Which column do you want to use for entering the value $5.00?
Assuming it is G, then enter this in G1
=IF(F1="Y",5,"")
and copy it down. It will show a blank unless Col F in the same row has an "Y"

Format Col G as Currency to show $5.00
"Peekaboo012885" wrote:

I'm trying to put together a commission spreadsheet and want to assign just
one numeric value to an entire column, however, I only want the data inputted
for cells used. Ex: Column F is for protection plans sold....if "Y" is
entered then the value should equal "$5.00", if left blank then no value is
entered into the cell. Does anyone know how to acheive this?

Assigning a single value to a column
 

Hm...Well I want it to end up totaling it all at the bottom of colum F
instead of an ajacent column...but thanks for the reply. Does this make any
sense?

"Sheeloo" wrote:

Which column do you want to use for entering the value $5.00?
Assuming it is G, then enter this in G1
=IF(F1="Y",5,"")
and copy it down. It will show a blank unless Col F in the same row has an "Y"

Format Col G as Currency to show $5.00
"Peekaboo012885" wrote:

I'm trying to put together a commission spreadsheet and want to assign just
one numeric value to an entire column, however, I only want the data inputted
for cells used. Ex: Column F is for protection plans sold....if "Y" is
entered then the value should equal "$5.00", if left blank then no value is
entered into the cell. Does anyone know how to acheive this?

Assigning a single value to a column
 

You can enter this in any cell outside the range in the formula

=5*SUMPRODUCT(--(F1:F100="Y"))

It will count the number of cells in the range F1:F100 having an Y and
multiply the count by 5...

"Peekaboo012885" wrote:

Hm...Well I want it to end up totaling it all at the bottom of colum F
instead of an ajacent column...but thanks for the reply. Does this make any
sense?

"Sheeloo" wrote:

Which column do you want to use for entering the value $5.00?
Assuming it is G, then enter this in G1
=IF(F1="Y",5,"")
and copy it down. It will show a blank unless Col F in the same row has an "Y"

Format Col G as Currency to show $5.00
"Peekaboo012885" wrote:

I'm trying to put together a commission spreadsheet and want to assign just
one numeric value to an entire column, however, I only want the data inputted
for cells used. Ex: Column F is for protection plans sold....if "Y" is
entered then the value should equal "$5.00", if left blank then no value is
entered into the cell. Does anyone know how to acheive this?