Results 1 to 4 of 4

Help with multiple IF statements & IF cell = blank

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Help with multiple IF statements & IF cell = blank

    Hi everyone, I've used your site for so many useful tips & tricks but have been unable to figure one thing. For example, If a certain weekly pass has been returned (Y or N in F10) to auto figure the total based on d11. The original value is in cell A11

    =IF(F11="Y",D11-15,IF(F11="N",D11)) Now this formula works great for me, but I do not want a return "False" I want it to also include the extra statement that if the cell is blank to equal the original A11 number.

    I've tried incorporating IFEMPTY and IFBLANK but I keep getting the error saying to get assistance entering a function blah blah blah...
    Last edited by zipper_018; 04-25-2011 at 04:56 PM.

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