Perhaps just change: .. OR(V8=49,X8=49)
to: .. AND(V8=49,X8=49)

Try it as:
=IF(OR(V8="",X8=""),"",IF(OR(V8="R",X8="R"),"R",IF (AND(V8=49,X8=49),"NGP",SUM(V8*0.18,X8*0.82)/100)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote:
Could someone have a look at this for me and give me feedback please:
=IF(OR(V8="",X8=""),"",IF(OR(V8="R",X8="R"),"R",IF (OR(V8=49,X8=49),"NGP",SUM(V8*0.18,X8*0.82)/100)))

Q8 is the destination cell so I want Q8 to produce NGP only if both V8 & X8
=NGP by entering 49 into both V8 & X8. However, if for argument sake V8 has
49 and X8 has 90 as it stands now Q8 still reads NGP but I want it to
actually calculate the score based on the SUM above and not give me an
NGP.... obviously the formula needs changing but I can't get my head around
exactly what needs to change.

Cheers
David