How do I make this work?
On Feb 13, 6:49*pm, Scoober wrote:
K27: If H27 is empty then K27 is to remain empty,
however if h27 is populated then k27 has the same
figure, however if 'Y' is entered into G27
then H27 is to be divided by 1.125
=if(H27="","",if(G27="Y",H27/1.125,H27))
|