ExcelBanter - logic test

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - logic test (https://www.excelbanter.com/excel-discussion-misc-queries/49386-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"?

tjtjjtjt

If yes and no are the only possibilities for K2, put this in M2:
=IF(K2="yes",H2,J2)
If there are other possibilities, the formula will need to be modified -
post back, if necessary.

--
tj

"toolman" wrote:

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

toolman

Thanks for your help!

"tjtjjtjt" wrote:

If yes and no are the only possibilities for K2, put this in M2:
=IF(K2="yes",H2,J2)
If there are other possibilities, the formula will need to be modified -
post back, if necessary.

--
tj

"toolman" wrote:

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 08:54 PM.