Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need assistance with wrting an Excel formula
I am attempting to write a formula that will calculate the variance between
the sum of a cell and the number 40, but only if the sum of that cell is greater than the number 40? I have tried several functions; i.e.: IF, SUMIF, Etc., but I am unable to crack it. Can you help? Much appreciated, M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
I need help figuring out this formula in Excel | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Create a formula in Excel? | Excel Worksheet Functions |