I'm trying to use an if function to pull info from one cell and equal another name per se in another cell. I think the problem is, I'm already using a quotation mark, so it's not reading the function correctly. .
I'm wanting to take the data that is in cell D5, (3/4" WOOD) and output 0.750.
My formula is as follows.
=IF(D5="3/4" WOOD",0.750)
Is there anyway to make excel ignore the " behind the 3/4??
Thanks in advance.
Bookmarks