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

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 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 K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)

Solved by E. S. in 26 mins

If cell f16 is greater than 0 them multiply the total by 102 and subtract 127.5.

Solved by B. Y. in 16 mins

=IF(AND(D11>0,F11>0)(D11^2+F11^2)^.5)0) if cell D11is greater than 0 AND F11> 0 then D11^2+F11^2)^.5)0 else 0

Solved by S. A. in 27 mins