Is there a formula to do the following

[Guest]

if a certain letter is placed into a cell such as "y" (for yes) can it make
anouther cell with info taken from still anouther cell. Example in rows B2
through B72 we will make as a withdrawl from a bank account. now in G2
through G72 we make as is this a taxable expence Y for yes N for no. we will
make H2 through H72 taxable total. Now say $22.00 is placed in B2 and Y is
selected in G2 is there a way to get the amount in B2 over to H2 automaticly
when Y is selected using a fomula.

 

[T. Valko]

Try this:

Enter this formula in H2 and copy down to H72:

=IF(AND(ISNUMBER(B2),G2="Y"),B2,"")

Biff