Results 1 to 7 of 7

usin < as part of my data

Threaded View

  1. #3
    Registered User
    Join Date
    12-08-2011
    Location
    Manteca
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: usin < as part of my data

    Im so excited it worked. thanks... so i decided to try the second equation first and works great. is there a way to get the result to only show whole number unless the value is less than 10, then would only have one decimal... thanks your awsome

    when I use the second method, the cells that use all numerical values keep the format to show no decimals, but the ones that use the < all show the decimals.

    any ideas?
    Thanks
    Last edited by sandraleeann; 12-08-2011 at 06:34 PM. Reason: to add info

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