Results 1 to 5 of 5

If question

Threaded View

david_pt If question 12-19-2009, 12:14 PM
JBeaucaire Re: If question 12-19-2009, 01:38 PM
david_pt Re: If question 12-19-2009, 03:32 PM
JBeaucaire Re: If question 12-19-2009, 04:28 PM
david_pt Re: If question 12-19-2009, 05:31 PM
  1. #1
    Registered User
    Join Date
    12-05-2008
    Location
    Portugal
    Posts
    19

    If question

    So I got data organised in a table, from A to H.

    A3:G10 is normal data...
    In H3:H10 it shows blank or an *.

    1) In collumn J, I want to specify if in those H3:H10 it finds any *. If it finds any, a word like "incompatible" will appear; if not, "compatible" will appear.
    2) Furthermore, let's say I want not only the condition imposed in 1), but also I ask it to look at a value in a cell and see if it's superior to 10. IF both are met, it shows "compatible", if one fails, "imcompatible".

    I guess it's a simple question but I couldn't figure it out.
    Thanks
    Last edited by david_pt; 12-19-2009 at 12:19 PM.

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