Results 1 to 8 of 8

If then statement? [Show result only when it's >0]

Threaded View

  1. 03-28-2018, 04:12 PM #1
    rbiankowski
    rbiankowski is offline
    Registered User
    Join Date
    12-29-2015
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    9

    Unhappy If then statement? [Show result only when it's >0]

    I need to create an IF THEN formula for a cell. Basically this but needs to be translated into excel language:

    (F6-B2) only if the quantity is greater than 0

    Sidenote: I'd like to be able to drag the formula down a column as well. F changes but B2 should stay the same number.
    Last edited by 6StringJazzer; 03-29-2018 at 08:45 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. nested IF statement or AND? trying to write an IF statement with multiple conditions
    By kcphila in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  2. [SOLVED] If statement to select data - nested statement - assistance
    By petitesouris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-29-2015, 09:55 PM
  3. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  4. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  5. [SOLVED] Convert If statement with cell row reference calculations to vlookup statement
    By excyclist in forum Excel General
    Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  6. VBA- Compile Error, Expected: line number or label or statement or end of statement
    By RLK7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  7. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1