Here are some problems that our users have asked and received explanations on
If a calculated cell is less than 0 = 0, if the same cell is greater that 0 that multiplied by 12 a1:a4 if greater than zero a5 x 12 if a5 is less than 0 = 0
Solved by G. H. in 21 mins
I need a formula that states if Cell C contains 0 then Cell D = 0 but if Cell C contains any number greater than 0 then Cell D will equal the sum of Cells A and B
Solved by V. S. in 12 mins
I need a formula that will tell me the sum of cells that have a greater value than 0. Not the sum of the numbers in the cells but if its used =1 not used= 0 kind of sum.
Solved by M. U. in 20 mins
I have a problem regarding to Sum if greater than
Solved by C. F. in 12 mins
I need a formula that will say: IF b3/g3 = less 1% then state <1 if greater than <1 then state sum of b3/g3 if zero then state 0