Results 1 to 2 of 2

Thread: Microsoft Excel - How do you do those two problems??

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Location
    Cleveland, Ohio
    Posts
    5,486

    Microsoft Excel - How do you do those two problems??

    Two problems; how do you exactly do this?

    1) Write an IF function for cell H3 that assigns the value of cell A7 to cell H3 if the value in J7 is less than the value in cell Q2; otherwise have the IF function assign zero (0) to cell H3.

    2) Write an IF function for cell P8 that assigns the text, "OK" if the value in cell S3 is five times greater than the value in cell Q2; otherwise, have the IF function assign the text, "Not OK" to cell P8.
    You're the one sure thing I've found so you better stick around...
    Best Fireman in da House´10
    dedicated to the kindest,loveliest and always helpful man that one would be honored and proud to know........R.I.P. Dear Phred

  2. #2
    Join Date
    May 2005
    Location
    near Paris, France
    Posts
    3,165
    1) Write an IF function for cell H3 that assigns the value of cell A7 to cell H3 if the value in J7 is less than the value in cell Q2; otherwise have the IF function assign zero (0) to cell H3.
    It should be something like this:
    In H3, type =IF(J7
    2) Write an IF function for cell P8 that assigns the text, "OK" if the value in cell S3 is five times greater than the value in cell Q2; otherwise, have the IF function assign the text, "Not OK" to cell P8.
    In P8, type =IF(S3=(5*Q2),"OK","Not OK")

    I did not check if the formulas work. You can look in the Excel Help for explanation about the IF function and conditional formulas.

Similar Threads

  1. A Microsoft Christmas
    By RedHedd in forum General
    Replies: 1
    Last Post: 12-01-2006, 04:47 PM
  2. Microsoft Excel Question
    By catnapper in forum General
    Replies: 12
    Last Post: 03-17-2006, 11:20 AM
  3. Microsoft Office
    By moosmom in forum General
    Replies: 3
    Last Post: 01-29-2006, 08:58 PM
  4. Replies: 16
    Last Post: 09-18-2004, 03:26 PM
  5. Excel....
    By PayItForward in forum Cat General
    Replies: 22
    Last Post: 01-11-2004, 07:13 PM

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
  •  

Copyright © 2001-2013 Pet of the Day.com