I need a formula HELP!!!

Copper Contributor

I have a set of data that needs to read:

If C5 is less than 70 and C20 is less than 25% then equals to zero

 

This line needs to also be combined with 

=IF(C22<10,0,C25*C24)

 

1 Reply

Hi

 

My guess would be:

=NOT(OR(AND(C5<70<C20<25%),C22<10))*C25*C24