Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with formulas?

    I'm wondering if the following can be done, I have attached a spreadsheet, when a cell reads 0 in column B3 I would like that cell (B3) and cell A3 to read OFFLINE, is there a formula I can use?
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In A3:
    =if(B3=0,"OFFLINE","??")

    Substitute what you want in A3 when B3 is not zero.

    Use a custom format in B3:
    General;General;"OFFLINE"

    Change the generals above to whatever format you want for positive and negative numbers respectively...

    Steve

Posting Permissions

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