Ok thats got that working
So I thought that I could be clever & write the following but it don't work !
=IF(F5=0,J5:S5*0,IF(F5=1,J5:S5*17.5%,IF(F5=2,J5:S5 *5%,IF(F5=4,J5:S5/407*7,"NOT VALID VALUE"))))
What have I got wrong please ?
__________________
Colin
I trust my rebreather completely ,
I just don't trust the user
onwards & downwards
