Results 1 to 3 of 3

Thread: spreadsheet formulae

  
  1. #1
    Status
    Offline
    M1C VX's Avatar
    AOC Obsessed
    Join Date
    Dec 2003
    Posts
    1,377
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)

    spreadsheet formulae

    i want to make a spreadsheet in exel, strugglin with a formula

    if an amount is a positive (5000) or a negative (-5000) i want it to display a differnet value in another cell

    so for example If C47 is positive, display "phrase1" if negative display "phrase 2"

    ANYONE
    What is cross posting? Is it when you get angry and post it on a forum?

  2. #2
    Status
    Offline
    Steve_1.8sri's Avatar
    AOC Fanatic
    Join Date
    Dec 2004
    Posts
    565
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    put this in the cell you want the phrase in :-
    =IF(C47>=0,"phrase1","phrase2")

  3. #3
    Status
    Offline
    M1C VX's Avatar
    AOC Obsessed
    Join Date
    Dec 2003
    Posts
    1,377
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    cheers mate
    managed to work it out, couldnt think of the symbol for "greater than" lol
    What is cross posting? Is it when you get angry and post it on a forum?

Similar Threads

  1. iPhone 4 UK network comparison spreadsheet, including sim-only options
    By LEE69 in forum Chit Chat and a Warm Welcome!
    Replies: 28
    Last Post: 19-06-2010, 15:32

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •