Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formula Question (with a name)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Formula Question (with a name)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Formula Question (with a name)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula question D Hafer - TFE Excel Discussion (Misc queries) 1 January 9th 08 03:24 PM
IF formula question frozn1 Excel Discussion (Misc queries) 2 December 10th 06 06:52 AM
Formula question pie_terro Excel Worksheet Functions 4 June 26th 06 06:51 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
formula question Excel Worksheet Functions 1 November 22nd 05 08:26 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"