Results 1 to 6 of 6

IF and AND Nested Formulae

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    304

    IF and AND Nested Formulae

    Added amended Workbook
    Further to the previous solution from Haluk,
    [HTML](https://www.excelforum.com/excel-programming-vba-macros/1305739-how-to-use-wingdings-in-formulae.html#post5276267 [HTML] , I am trying to add more functions to the original solution.
    I am unsure where to go her so would appreciate a formula to include the original plus more functions.
    I believe IF & AND functions would probably be involved, but I don’t understand how to place these in the correct sequence.

    The attached WorkBook –C has example and expected outcome in Sheet1(2).
    Attached Files Attached Files
    Last edited by VisionSmart; 02-14-2020 at 08:04 AM. Reason: Amended Workbook

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code to replace formulae in cells and then re-enter same formulae again after run
    By excel_msa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2017, 06:56 AM
  2. [SOLVED] Nested IFS and multiple logical formulae
    By jdohlinger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2012, 01:41 PM
  3. Replies: 6
    Last Post: 05-20-2012, 02:37 PM
  4. Nested Formulae IF->AND
    By ZuttySingleton in forum Excel General
    Replies: 4
    Last Post: 10-09-2010, 08:34 AM
  5. Replace nested IF with other formulae...
    By contaminated in forum Excel General
    Replies: 3
    Last Post: 08-08-2009, 04:04 PM
  6. Nested If Formulae
    By stanleds in forum Excel General
    Replies: 15
    Last Post: 07-15-2009, 05:19 PM
  7. [SOLVED] Nested functions in conditional formatting formulae
    By Joseph in forum Excel General
    Replies: 3
    Last Post: 10-20-2005, 07: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