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?