Search:

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

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

by FreshlySqueezed
Replies
8
Views
160

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. Thread: I Just Don't Get Nested IF Statements

by FreshlySqueezed
Replies
8
Views
160

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. Thread: I Just Don't Get Nested IF Statements

by FreshlySqueezed
Replies
8
Views
160

Re: I Just Don't Get Nested IF Statements

still not working

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

by FreshlySqueezed
Replies
8
Views
160

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. Thread: I Just Don't Get Nested IF Statements

by FreshlySqueezed
Replies
8
Views
160

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. Thread: I Just Don't Get Nested IF Statements

by FreshlySqueezed
Replies
8
Views
160

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. Thread: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

by FreshlySqueezed
Replies
7
Views
200

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. Thread: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

by FreshlySqueezed
Replies
7
Views
200

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. Thread: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

by FreshlySqueezed
Replies
7
Views
200

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. Thread: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

by FreshlySqueezed
Replies
7
Views
200

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