Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
=IF(E4="Y",I4*M3,I4*M4)/if(or(h4="sam",h4="alex"),2,1) Regards, Fred "Wendy-Bob" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Fred, you're a star - that works a treat!
Wendy-Bob "Fred Smith" wrote: Try this: =IF(E4="Y",I4*M3,I4*M4)/if(or(h4="sam",h4="alex"),2,1) Regards, Fred "Wendy-Bob" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula question | Excel Discussion (Misc queries) | |||
IF formula question | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Worksheet Functions |