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
Bookmarks