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

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

Biff

"toolman" <toolman@discussions.microsoft.com> wrote in message
news:055EA71A-B5AF-47CC-986F-930282D82A10@microsoft.com...
> 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"?