Help,
I am trying to get a calculation to do the following.........
=If >800
Then * by 0.40
=If <800 then insert '0'
ie : if the cell contains a value of 914, it should display the value of 45.60, and if the cell contains a value less than 800, it should then display 0.
So I have been trying to do this.............
=if(A1>800,*0.40, if(A1<800,0))
But it does not work ?, can anyone help with this one ?
Bookmarks