Results 1 to 3 of 3

Thread: if statment

  1. #1

    if statment



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i appreciate your help
    i need something to add .04 percent tax if the figure is $45000 or greater
    lets sale b2 is my selling price then b7 would be 0 unless b2 is $45k or more thanks

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    The formula in B7 could be:
    =IF(B2>45000,B2*.04,0)

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.mrexcel.com/forum/excel-q...nt-please.html

    search4f, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •