Hi below is an if statement that I cnnot get to work for some reason.
the value returned from C71/C70 will be a decimal value.
that way it is know it only retuns 1 or 0
=IF(C71/C70>=1,"1",IF(C71/C70>=1.15,"2",IF(C71/C70>=1.3,3,IF
(C71/C70>="1.45",4,0))))
the value returned from C71/C70 will be a decimal value.
that way it is know it only retuns 1 or 0
=IF(C71/C70>=1,"1",IF(C71/C70>=1.15,"2",IF(C71/C70>=1.3,3,IF
(C71/C70>="1.45",4,0))))