Hi Dave O

Try this:
=IF(AND(C5="no",G5=195),0,IF(AND(C5="no",G5=0),195 ,IF(AND(C5="yes",G5=750),0,IF(AND(C5="yes",G5<750) ,(750-G5)*0.5,""))))

You do no specify what should happen when not one of your conditions are
met, hence the "" at the end, otherwise G5 will read FALSE

HTH

"Dave O." wrote:

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%