Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RS RS is offline
external usenet poster
 
Posts: 113
Default If, Then Statements

Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is?

i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100)

or simpler ... If B1<5, then C1

or If B1=the numbers 5-10, then D1(formula)

If B110, then E1(formula)

Any help would be much appreciated!! Thanks!!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default If, Then Statements

Dave,
I've also been completely stuck with a coversion chart and am not sure what
type of "IF" or "LOOKUP" might solve my problem.

I need to have a valur replace a grade entered. However, that grade may
either be numberical or not. For example:

if grade is entered as 94 the it shoukld be replace as 4.0, if it's entered
as A it should be replaced with 4.0.

Can you offer a suggestion?

"Dave F" wrote:

Yeah, you can do that:

=IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1)

Dave
--
Brevity is the soul of wit.


"RS" wrote:

Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is?

i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100)

or simpler ... If B1<5, then C1

or If B1=the numbers 5-10, then D1(formula)

If B110, then E1(formula)

Any help would be much appreciated!! Thanks!!!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 623
Default If, Then Statements

You want something like:

=if(isnumber(a1),vlookup(a1,Sheet2!A:B,2,true),vlo okup(a1,Sheet2!C:D,2,false))

--
Regards,
Fred


"Angie" wrote in message
...
Dave,
I've also been completely stuck with a coversion chart and am not sure what
type of "IF" or "LOOKUP" might solve my problem.

I need to have a valur replace a grade entered. However, that grade may
either be numberical or not. For example:

if grade is entered as 94 the it shoukld be replace as 4.0, if it's entered
as A it should be replaced with 4.0.

Can you offer a suggestion?

"Dave F" wrote:

Yeah, you can do that:

=IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1)

Dave
--
Brevity is the soul of wit.


"RS" wrote:

Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is?

i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100)

or simpler ... If B1<5, then C1

or If B1=the numbers 5-10, then D1(formula)

If B110, then E1(formula)

Any help would be much appreciated!! Thanks!!!



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
Multiple IF statements or a better method ? Bob Moore Excel Discussion (Misc queries) 4 November 25th 06 02:20 AM
2 IF Statements not mutually exclusive Bev Excel Discussion (Misc queries) 2 August 24th 06 05:23 AM
UDFunctions and nested If-the-else statements JDB Excel Worksheet Functions 1 January 25th 06 04:29 PM
Linking two IF statements together trixma Excel Discussion (Misc queries) 2 September 29th 05 06:07 AM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 07:17 AM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"