“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by I. S. in 25 mins