+ Reply to Thread
Results 1 to 2 of 2

if test using true/false or yes/no

  1. #1
    toolman
    Guest

    if test using true/false or yes/no

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

  2. #2
    B. R.Ramachandran
    Guest

    RE: if test using true/false or yes/no

    Hi,

    If K2 always contains either "yes" or "no" (i.e., never empty), enter the
    following formula in M2

    =IF(K2="yes",H2,J2)

    If K2 can also be empty at times and if you do not want to have any answer
    in K2 in such a situation, use the formula,

    =IF(K2="yes",H2,IF(K2="no",J2,""))

    In either case, format M2 to 'currency'.

    Regards,
    B. R. Ramachandran

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1