Hi David

I'm assuming you're putting the formula in cell H5

=IF(C5="no",IF(G5=195,0,IF(G5=0,195,"something else
1")),IF(C5="yes",IF(G5=750,0,IF(G5<750,(750-G5)*50%,"something else
2")),"something else 3"))

replace
something else 1 with what you want when C5 = "no" and G5 is neither 0 or
195
something else 2 with what you want when C5 = "yes" and G5 is not <=750
something else 3 with what you want when C5 is neither no nor yes
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Dave O." <Dave wrote in message
...
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%