+ Reply to Thread
Results 1 to 2 of 2

If, Then statements with a formula

  1. #1
    Michelle
    Guest

    If, Then statements with a formula

    I am trying to set up an If, Then statement in which I reference a cell. The
    cell value can be a negative or positive number.

    For example:

    Column A is a number 1-999
    Column B is a positive or negative or blank
    Column C is a percentage if column B is negative only

    Can anyone help set this formula up?

    Thanks

  2. #2
    Registered User
    Join Date
    01-24-2006
    Location
    Wisconsin
    Posts
    5

    I would try here

    http://spreadsheets.about.com/cs/excelfunction1/a/iffunction.htm

    This site has pretty good explaination for the if, then statement. It gets into nested statements and things like that as well. It helped when I needed a little help in this same area.


+ 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