ganit-core 0.3.4

Spreadsheet formula engine — parser and evaluator for Excel-compatible formulas
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

use super::super::averageifs_fn;
use crate::types::{ErrorKind, Value};

#[test]
fn no_matches_returns_div_zero() {
    // avg_range=5.0, crit_range=1.0, criteria=99.0 → no rows match → #DIV/0!
    assert_eq!(
        averageifs_fn(&[Value::Number(5.0), Value::Number(1.0), Value::Number(99.0)]),
        Value::Error(ErrorKind::DivByZero)
    );
}

#[test]
fn multiple_criteria_all_must_match() {
    // avg_range=7.0, crit_range1=10.0 criteria1=10.0, crit_range2=20.0 criteria2=20.0
    // Both match → average(7.0) = 7.0
    assert_eq!(
        averageifs_fn(&[
            Value::Number(7.0),
            Value::Number(10.0),
            Value::Number(10.0),
            Value::Number(20.0),
            Value::Number(20.0),
        ]),
        Value::Number(7.0)
    );
}

#[test]
fn multiple_criteria_one_fails_returns_div_zero() {
    // avg_range=7.0, crit_range1=10.0 criteria1=10.0, crit_range2=20.0 criteria2=99.0
    // Second criterion fails → no match → #DIV/0!
    assert_eq!(
        averageifs_fn(&[
            Value::Number(7.0),
            Value::Number(10.0),
            Value::Number(10.0),
            Value::Number(20.0),
            Value::Number(99.0),
        ]),
        Value::Error(ErrorKind::DivByZero)
    );
}