Results 1 to 9 of 9

need a nested if/and formula for a single cell sorted out - semi complex but beyond me

Threaded View

Omegaman2 need a nested if/and formula... 10-11-2013, 08:49 PM
azumi Re: need a nested if/and... 10-11-2013, 09:17 PM
NU2vba Re: need a nested if/and... 10-11-2013, 09:22 PM
Omegaman2 Re: need a nested if/and... 10-11-2013, 10:32 PM
Omegaman2 Re: need a nested if/and... 10-11-2013, 10:38 PM
SDCh Re: need a nested if/and... 10-11-2013, 10:49 PM
NU2vba Re: need a nested if/and... 10-12-2013, 04:06 PM
Omegaman2 Re: need a nested if/and... 10-15-2013, 02:14 PM
Omegaman2 Re: need a nested if/and... 10-15-2013, 02:08 PM
  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    High Desert, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    need a nested if/and formula for a single cell sorted out - semi complex but beyond me

    The spreadsheet must remain on one sheet. Cells, f3,f4,f5,and f6 are all for input purposes. The formula in cell f 8 is currently =(((F3/12)*2)*F6)+(((F4*60)+F5)*0.84)-30 and works perfectly in most cases. However, I need it to modify it's behavior under certain cases. Case 1: If f3=15 or less AND f5=22 or less, then f8 should display "FREE". Case2= Any time that f8 would return 0 or less (a negative number), f8 should display "FREE". No other cells are available for calculations, so all trickery must be preformed within cell f8.
    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. Help needed top break the complex nested if formula
    By chandra 2185 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 02:50 PM
  2. [SOLVED] Nested formula required for two cell inputs and a single cell output
    By titch2k6 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2013, 08:11 PM
  3. Replies: 6
    Last Post: 02-06-2013, 07:45 PM
  4. Complex nested array formula problem and challenge
    By PeterWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2007, 10:34 PM
  5. semi-complicated nested IF statement
    By tjb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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