Results 1 to 3 of 3

Complicated nested formula assistance (believe I can use "if" formula, not 100% sure)

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel for M365
    Posts
    53

    Exclamation Complicated nested formula assistance (believe I can use "if" formula, not 100% sure)

    Hi everyone,

    Please see my problem below (file attached):

    I believe I only need to write one formula and it can be applied to columns K-N. I was going to use customer number (as opposed to name) when I wrote the formula.

    Here are the parameters:
    - If invoice is over BRL 5,000.00 (column F) and customer is Americel, Claro, Nextel or Tim Cellular – then columns K-N should be billed amount (column F) multiplied by tax rate (amounts in row 3, columns K-N).
    o Any invoice amount under BRL 5,000 (column F) for the above customers – then column K should be billed amount (column F) multiplied by tax rate (in row 3, column K) and columns L-N should be zero.
    o However, if invoice tax amount is under BRL 10.00 (column G) for above customers – then columns K-N should be 0
    - Customer Vivo should be zero for columns K-N.

    Thanks in advance for your assistance,
    Jessica
    Attached Files Attached Files

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