ExcelBanter - logic test

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - logic test (https://www.excelbanter.com/new-users-excel/49396-logic-test.html)

toolman

logic test

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"?

Biff

see replies in one of the other forums this was posted to.

Biff

"toolman" wrote in message
...
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"?

All times are GMT +1. The time now is 06:45 PM.