Results 1 to 8 of 8

Help Creating a IF Statement

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Manchester
    MS-Off Ver
    Excel 2003 + 2007
    Posts
    18

    Help Creating a IF Statement

    Hello I have a spreadsheet

    From cells A5 to A10 i have item names
    Cell B5 to B10 i have the items stock e.g 100, 50

    In Cells C5 to C10 i would like to make a IF statement

    =IF(B12>30,"Stock Valid","Stock replacing"

    how do i edit this so that not only does it show

    when stock level is above 30 its should say Stock Valid - This works
    When stock level is below 30 it shows Stock replacing -- This Works

    How do i make it say when stock level is 0 - it should say Order

    Thank You
    Last edited by markhuges; 10-30-2011 at 04:00 AM. Reason: Solved

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