04-20-2011, 04:17 AM
input "E" only accepts values of 200000 and 29000000 for it to work
as coded in cell E11
=IF($D$11=200000,"MPa",IF($D$11=29000000,"psi",""))
that is to trap and protect WRONG inputs!!!
Notes: my professor once told me not to rely on codes written by others.
please double check results,
RedHorse at ur service
as coded in cell E11
=IF($D$11=200000,"MPa",IF($D$11=29000000,"psi",""))
that is to trap and protect WRONG inputs!!!
Notes: my professor once told me not to rely on codes written by others.
please double check results,
RedHorse at ur service
Engineering is the professional art of applying science to the optimum conversion of natural resources to the benefit of man