Formula Question (with a name)

[Wendy-Bob]

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

 

[Fred Smith]

Try this:

=IF(E4="Y",I4*M3,I4*M4)/if(or(h4="sam",h4="alex"),2,1)

Regards,
Fred

 

[Wendy-Bob]

Thanks Fred, you're a star - that works a treat!

Wendy-Bob