+ Reply to Thread
Results 1 to 4 of 4

simple IF condition

  1. 03-29-2023, 12:57 AM #1
    Shark Man
    Shark Man is offline
    Registered User
    Join Date
    04-15-2009
    Location
    Israel
    MS-Off Ver
    Excel 2019
    Posts
    79

    simple IF condition

    Hi Experts

    What's wrong with my formula:

    =IF(F37>=1,IF(F39="YES",F36*F37*22.5),0),0

    Thanks
    Reply With QuoteRegister To Reply
  2. 03-29-2023, 01:08 AM #2
    johnnyL
    johnnyL is offline
    Valued Forum Contributor
    Join Date
    11-27-2011
    Location
    usa
    MS-Off Ver
    Excel 2007, Excel 365
    Posts
    495

    Re: simple IF condition

    Try saying in words what you are trying to do.
    Reply With QuoteRegister To Reply
  3. 03-29-2023, 01:17 AM #3
    Shark Man
    Shark Man is offline
    Registered User
    Join Date
    04-15-2009
    Location
    Israel
    MS-Off Ver
    Excel 2019
    Posts
    79

    Re: simple IF condition

    Thanks

    IF F37>=1 THEN
    I WANT TO CHECK IF F39="YES"
    IF F39="YES" THEN F36*F37*22.5
    IF NO THEN 0

    IF F37<1 THEN 0
    Reply With QuoteRegister To Reply
  4. 03-29-2023, 02:07 AM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,606

    Re: simple IF condition

    Try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple planning with two condition
    By JBORSAY in forum Excel General
    Replies: 2
    Last Post: 06-01-2020, 07:18 AM
  2. [SOLVED] IF/OR/AND Condition (Simple)
    By mackan7695 in forum Excel General
    Replies: 2
    Last Post: 08-16-2016, 02:07 AM
  3. Help for simple Macro with one condition
    By yozone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2015, 12:48 PM
  4. Simple if condition
    By magic_ma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-25-2013, 06:24 AM
  5. Please Help to get a value from a column with simple condition
    By vpnvipin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2012, 06:09 AM
  6. Simple Condition Question
    By Losse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2010, 10:44 PM
  7. Add Condition to simple formula
    By KennyE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2009, 01:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1