Specific character (Y/N ) corresponds to a number in adjacent row

Hi there,

I am trying to design a spreadsheet where I can just answer Y/N, and that the Y would correspond to a number in that row. This will need to be repeated hundreds of times and would save a lot of data entry time. Any help would be greatly appreciated!

Thanks,

Sarosh

say your answer starts at Cell A1 (contains Y or N)
in cell B1(this is where the value should be)


=if(A1="Y",100,200) -> then use the fill handle to drag the formula down.

is this what you are looking for?

there is a fill handle used in excel to fill values or formulas all the way down or across..
in an active cell you'll notice a small square below right corner of the active cell that's the fill handle.. better you could google it up so you could see pictures. I can't upload pictures now.

btw:

if works like this

=if(your condition,condition is true,condition is false)
your condition is Y or N