View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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))