Results 1 to 6 of 6

Multiples of a # formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2008
    Location
    Bay Area
    Posts
    14

    Multiples of a # formula

    Is it possible to have a forumla that gives a True or False (perferably if it's possible for a conditional formatting to change colors) for multiples of a number.
    I would input a number in the cell and it would change the cell color if it not a multiple of say for example 13.
    Last edited by Alpha Zero; 10-15-2008 at 06:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. A formula template
    By ajaysehgal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2013, 06:12 AM
  3. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. use cell content as cell address in formula
    By nnsc in forum Excel General
    Replies: 4
    Last Post: 11-05-2006, 03:12 AM

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