logic test

T

toolman

What formula would I use to say: [M2] = [H2] if [K2=yes], [M2] = [J2] if
[K2=no], when cells [M2], [H2], and [J2] are dollar amounts, and [K2] is
actually the word "yes" or "no"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Would like to input 3 letters into a cell, each having a different numerical value 5
Dividing after a long formula 5
Formula Help PLEASE!!!! 1
if test using true/false or yes/no 1
Bold items within text string 7
Percentage difference 6
concatenate more column value 3
Runtime Error on Linest 3

Top