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
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).
