Search:

Type: Posts; User: FreshlySqueezed; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: I Just Don't Get Nested IF Statements

    Solved the final barrier - changed IF(ISNUMBER to IF(ISTEXT

    That way, the leading zero stays in the concatenated string, though l have to manually enter it for each single digit number to begin...
  2. Re: I Just Don't Get Nested IF Statements

    Solved it. The source columns (X Y Z aka N O P) were formatted to text.

    Unfortunately, when l format them to number, they cannot show the leading zero for single digit numbers, which is essential...
  3. Re: I Just Don't Get Nested IF Statements

    still not working

    For clarity could you alter the formula l posted:...
  4. Re: I Just Don't Get Nested IF Statements

    Here is the actual formula (concatenation part slightly shortened for brevity, note also that the columns are actually N,O,P):
    ...
  5. Re: I Just Don't Get Nested IF Statements

    Right, so what is wrong with this line:

    IF(ISNUMBER($Z1),CONCATENATE($X1 ... $Y1 ... $Z1 ...),IF(ISNUMBER($Y2),CONCATENATE($X1 ... $Y1 ...),IF(ISNUMBER($X1),CONCATENATE($X1 ...),"")))

    (the...
  6. I Just Don't Get Nested IF Statements

    3 columns
    1 row:

    $X1
    $Y1
    $Z1


    If there's a number in any of these, l want to trigger a concatenation involving the data in that specific cell.
  7. Re: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Hi there thanks,

    My intention was: First element = There's an eBay fee cap. The fee cap has been exceeded by the actual eBay fees, so fee cap is triggered. Also, PayPal fees are greater than...
  8. Re: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Indeed it does, congratulations you've solved it!

    Still, wish l knew what was wrong with my formula, but l'm happy to close the book on it anyhow.





    Quoting the previous post: eBay Item...
  9. Re: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Hi there thank you for your reply.

    Your formula gives a value that looks like it should be right and l could quickly crunch some numbers but l did a simple acid test: Change eBay Fee Cap (the...
  10. Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Hello, l am using LibreOffice Calc but l'm hoping it won't affect matters.


    KEY TO EXPRESSIONS:


    $AG$3 = PayPal fee percentage
    $AG$4 = PayPal fixed fee per transaction (e.g. 0.30 per...
Results 1 to 10 of 10