Nested IF

Occasional Visitor

I Am a college student doing Excel Homework specifically a nested if using both the IF function and the SUM function in the same formula I need the Sum number for the value if false number and I Can't figure out how to write the end of the formula. please help if you can

1 Reply
If you use sum function to get the value from true or false, do not forget to use double minus sign-- in your formula. For e.g You write Sum(--(Age>=18)) instead of Sum(Age>=18)
If function is simple, If( logical_test, value_if_true, value_if_false).