Hi there,

I don't do a lot of complex formulas and have been a little flummoxed on
this one if anyone can give me a hand please!

I have an IF formula (which is working fine on its own) but what I want to
do is effectively another IF on top of this. The second IF includes names
though and this is where I'm totally lost!

This is the first IF:
=IF(E4="Y",I4*M3,I4*M4)

What I then want to do is
If H4 is equal to Sam or Alex, then divide by 2
If not then just leave as is/divide by 1

I have tried defining the names as "=2" and adding "/H4" at the end of the
IF, but the formula doesn't like it in the sum.

Any assistance would be greatly appreciated!

Thanks,

Wendy-Bob