Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Combining <= and >= in same formula for time calculation 1
- AussieNat
May 26, 2016 at 2:26 AM
- AussieNat
May 26, 2016 at 1:22 PM
-
- Replies
- 1
- Views
- 821
1
-
-
-
-
Payroll timesheet with complex payrate structure needing formula variation 1
- AussieNat
May 18, 2016 at 12:55 PM
- AussieNat
June 6, 2016 at 10:57 AM
-
- Replies
- 1
- Views
- 1.1k
1
-
-
-
-
Balance carried forward 2
- Aussiebuilder
April 23, 2017 at 1:18 AM
- Aussiebuilder
April 23, 2017 at 8:06 AM
-
- Replies
- 2
- Views
- 1.9k
2
-
-
-
-
Index & match 2
- Aussiebuilder
April 23, 2017 at 1:11 AM
- Aussiebuilder
April 23, 2017 at 2:02 AM
-
- Replies
- 2
- Views
- 870
2
-
-
-
-
If & carried forward balances 1
- Aussiebuilder
April 21, 2017 at 4:48 PM
- Aussiebuilder
April 21, 2017 at 5:09 PM
-
- Replies
- 1
- Views
- 590
1
-
-
-
-
Countif & min 7
- Aussiebuilder
April 16, 2017 at 2:50 AM
- Aussiebuilder
April 18, 2017 at 9:13 PM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Copy Range of cells x times in order 2
- AttallaEA
February 22, 2018 at 12:28 PM
- AttallaEA
February 22, 2018 at 8:57 PM
-
- Replies
- 2
- Views
- 348
2
-
-
-
-
Formula to Find Current or Future based on specific date 2
- Aswinraj11
July 3, 2018 at 8:11 AM
- Aswinraj11
January 28, 2019 at 2:49 AM
-
- Replies
- 2
- Views
- 419
2
-
-
-
-
Calculate No of Working days between two specific days excluding weekends 8
- Aswinraj11
June 21, 2018 at 2:55 PM
- Aswinraj11
July 3, 2018 at 7:41 AM
-
- Replies
- 8
- Views
- 1.1k
8
-
-
-
-
Formula to compare two values using prefix/suffix 5
- Aswinraj11
June 15, 2018 at 3:12 AM
- Aswinraj11
June 21, 2018 at 2:41 PM
-
- Replies
- 5
- Views
- 881
5
-
-
-
-
COUNT two or more consecutive text values and check each if it's +/- than a value 20
- aspasovski86
August 20, 2018 at 11:24 PM
- aspasovski86
August 27, 2018 at 2:04 PM
-
- Replies
- 20
- Views
- 2.1k
20
-
-
-
-
Selecting cells using the IF function in multiples 2
- ashming
October 16, 2019 at 1:13 AM
- ashming
October 27, 2019 at 2:17 AM
-
- Replies
- 2
- Views
- 797
2
-
-
-
-
VlookUp Crawls 3
- asdf_99
June 30, 2022 at 3:34 PM
- asdf_99
July 11, 2022 at 1:16 AM
-
- Replies
- 3
- Views
- 580
3
-
-
-
-
Ignore blank cells in array formula 2
- artsjeroen
March 10, 2016 at 2:51 PM
- artsjeroen
March 10, 2016 at 3:38 PM
-
- Replies
- 2
- Views
- 3k
2
-
-
-
-
Count Based On Specific Criteria and Reset If Blank Encountered 5
- Artemis2018
December 29, 2021 at 12:40 AM
- Artemis2018
December 31, 2021 at 2:37 AM
-
- Replies
- 5
- Views
- 922
5
-
-
-
-
Copy-paste-values from a formula results in an apostrophe
- arrkwill
October 16, 2018 at 11:56 AM
- arrkwill
October 16, 2018 at 11:56 AM
-
- Replies
- 0
- Views
- 611
-
-
-
-
syntax of excel formula withindirect 4
- arlener
November 8, 2021 at 11:05 PM
- arlener
November 9, 2021 at 4:51 PM
-
- Replies
- 4
- Views
- 566
4
-
-
-
-
Formula Correction Required 4
- ArhamRajput
June 15, 2020 at 3:20 PM
- ArhamRajput
June 15, 2020 at 4:33 PM
-
- Replies
- 4
- Views
- 876
4
-
-
-
-
Formula Required
- ArhamRajput
May 22, 2020 at 4:51 PM
- ArhamRajput
May 22, 2020 at 4:51 PM
-
- Replies
- 0
- Views
- 396
-
-
-
-
Separation Formula Required 2
- ArhamRajput
February 28, 2020 at 5:50 PM
- ArhamRajput
February 29, 2020 at 7:56 AM
-
- Replies
- 2
- Views
- 744
2
-