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%

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%

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%