Here are some problems that our users have asked and received explanations on
I need a COUNTIF criteria that finds the number of entries that are "less than .1 but no greater than .2".
Solved by G. C. in 16 mins
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 to format computed cells with value greater than zero. Ive tried various conditions, none work
Solved by D. E. in 26 mins
NEED A FORMULA., IF THE VALUE IN L1 IS GREATER THAN ZERO THE VALUE IN H1 MUST CHANGE TO 0
Solved by A. A. in 19 mins
I need a formula to calculate, ifg8=zero then make e19 zero, but if e8 is greater than 1 then add up e13 to e19 and populate e19 with this total. Regards Louise