i am trying to figure out how to make a formula multiply a cell by 2 if a certain cell has a y in it and multiply it by 1 if that cell has a n in it.. let me try ex:

cell A=4 cell B has a "y" then cell C would be cell A*2 or if cell A=4 cell B has a "n" then cell C would be cell A*1..

so if there was a y cell b then c would be 8 and if there was a n in cell b then cell c would be 4 ....

hope that makes since

please forgive my ignorance