I'm stumped. The cell I need to match has " in it. How do I write the function so that those quotation marks don't get mixed up with the formatting quotation marks?
=IF(Proposal!F107=96",C42,IF(Proposal!F107=120",D42,IF(Proposal!F107=144",E42,IF(Proposal!F107=168",F42,POR))))
Bookmarks