Questions tagged [worksheet-function] - KnowledgeHub

Questions tagged worksheet-function

10 questions

Sort by: Newest Votes Active

10

votes

4

answers

Get values from last 3 non-blank cells in a row

vba excel worksheet-function

asked 2013-04-28T11:15:09.397

12

votes

15

answers

Have Excel formulas that return 0, make the result blank

excel worksheet-function

asked 2013-03-06T05:13:38.167

10

votes

2

answers

How do I only count visible rows when using the COUNTIFS function?

excel excel-formula worksheet-function

asked 2013-01-14T17:09:51.287

12

votes

4

answers

In Excel, how to round to nearest fibonacci number

excel rounding worksheet-function fibonacci

asked 2011-06-28T15:47:27.053

9

votes

3

answers

Get parent folder path from file path using cell formula

excel worksheet-function

asked 2011-03-31T18:51:12.757

28

votes

5

answers

XIRR Calculation

c# algorithm math worksheet-function

asked 2011-03-03T11:03:41.397

94

votes

9

answers

How to turn a string formula into a "real" formula?

excel string formula worksheet-function evaluate

asked 2010-12-17T15:17:28.207

14

votes

5

answers

Excel function to get first word from sentence in other cell

excel worksheet-function

asked 2010-11-24T07:18:30.420

40

votes

11

answers

How do I slice an array in Excel VBA?

arrays excel vba worksheet-function

asked 2008-10-06T16:54:46.750

14

votes

13

answers

Rounding in MS Access

excel vba ms-access rounding worksheet-function

asked 2008-09-26T00:30:29.713