View Single Post
  #1   Report Post  
Dave O.
 
Posts: n/a
Default I need help with this formula

if cell c5=no and g5=195 then h5=0
if cell c5=no and g5=0 then h5=195
if cell c5=yes and g5=750 then h5=0
if cell c5=yes and g5=<750 then h5=750-g5*50%