If F20 becomes "Payoff - Quoted" then the value in M20 will need to now be the same as the value in N20. How do I write that formula?
If F20 becomes "Payoff - Quoted" then the value in M20 will need to now be the same as the value in N20. How do I write that formula?
=IF(F20="Payoff - Quoted",N20,"")
Give that a try!