+ Reply to Thread
Results 1 to 2 of 2

IF Function

  1. #1
    Registered User
    Join Date
    03-23-2016
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    17

    IF Function

    Hi everyone,

    Please could you help me with the following problem I am having with calculating a database.

    I have a database of numbers

    Product / Units / Profit Margin

    Prod A 1 100
    Prod B 2 200
    Prod C 0 100

    To calculate how much profit per piece I can insert a basic sum Profit Margin / Units - However I would like to also see if there is a 0 how much the profit margin should be - So it should be =IF(=>1,Profit Margin/Units),(<0,=Profit Margin)

    Does anyone know which function I could use to help to get to calculate this please?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: IF Function

    Wouldn't that be

    =IF(B2>0,C2/B2,C2)

    B2 = Units
    C2 = Profit Margin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-14-2017, 06:26 AM
  2. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  3. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  4. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  5. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Replies: 2
    Last Post: 03-20-2009, 01:29 PM

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