Results 1 to 5 of 5

Help with IF formula with combination of OR & And

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    14

    Help with IF formula with combination of OR & And

    I am trying to make a formula with following logic.

    statement . I have attached excel sheet for further explanation.





    if cell E3 is equal to "Desk" and cell d2 is equal to "buy" then cell I3 shoul show result of (F3+H2) OR if cell E3= "desk" and cell D2 is equal to "Sell" then Cell I3 should show result as (F2-H2)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to make the combination of numbers and total of that combination should be in range?
    By Darshan Shah in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 06-20-2020, 01:20 PM
  2. [SOLVED] IF Formula combination
    By Keibri in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-01-2015, 02:46 AM
  3. Replies: 2
    Last Post: 03-13-2015, 01:44 PM
  4. [SOLVED] Need help : If formula combination
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2014, 04:32 AM
  5. IF formula combination
    By lfhomet in forum Excel General
    Replies: 2
    Last Post: 11-24-2009, 08:11 AM
  6. [SOLVED] Help with a combination of formula's
    By Smiles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2006, 11:45 PM
  7. [SOLVED] Sum and If combination formula
    By Kim via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2005, 06:06 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