IF function for multiple variables
 

I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following format
from another post, but all i get is the very last number meaning that none of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

On Fri, 24 Aug 2007 10:00:00 -0700, DaS wrote:

I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following format
from another post, but all i get is the very last number meaning that none of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),I F(A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1 +(A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

There are many things you could be doing wrong. However, if you don't post the
actual formula you are using, we'd only be guessing. You also need to post the
exact contents, and formatting, of A3.

Clearly, the formula you posted is not looking for a Saturday or Sunday in A3.
--ron

IF function for multiple variables
 

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

A3 actually is a date 1/1/08, but its fromatted to display Tuesday. 172 is
what's input in to the formulated cell, so that tells me it's not recognizing
a3's cell contents. Sorry about the lack of information previously.

I tried the =IF(A3="Saturday",22,IF(A3="Sunday",75,0)) formula and all it
returned was a -...it was even tried on a cell that displayed Sunday.

Thanks for your help everyone

"T. Valko" wrote:

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

On Fri, 24 Aug 2007 10:52:05 -0700, DaS wrote:

=if(a3="Saturday",420,if(a3="sunday",348,if(a3="f riday",378,172)))

=IF(WEEKDAY(A3)=7,420,IF(WEEKDAY(A3)=1,348,IF(WEEK DAY(A3)=6,378,172)))
--ron

IF function for multiple variables
 

Try this:

=IF(A3="","",CHOOSE(WEEKDAY(A3,2),172,172,172,172, 378,420,348))

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

A3 actually is a date 1/1/08, but its fromatted to display Tuesday. 172 is
what's input in to the formulated cell, so that tells me it's not
recognizing
a3's cell contents. Sorry about the lack of information previously.

I tried the =IF(A3="Saturday",22,IF(A3="Sunday",75,0)) formula and all it
returned was a -...it was even tried on a cell that displayed Sunday.

Thanks for your help everyone

"T. Valko" wrote:

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text
of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22.
If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that
none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

That did it Ron, thank you very much!

"DaS" wrote:

I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following format
from another post, but all i get is the very last number meaning that none of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

Slight tweak:

=IF(COUNT(A3),CHOOSE(WEEKDAY(A3,2),172,172,172,172 ,378,420,348),"")

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=IF(A3="","",CHOOSE(WEEKDAY(A3,2),172,172,172,172, 378,420,348))

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

A3 actually is a date 1/1/08, but its fromatted to display Tuesday. 172
is
what's input in to the formulated cell, so that tells me it's not
recognizing
a3's cell contents. Sorry about the lack of information previously.

I tried the =IF(A3="Saturday",22,IF(A3="Sunday",75,0)) formula and all it
returned was a -...it was even tried on a cell that displayed Sunday.

Thanks for your help everyone

"T. Valko" wrote:

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text
of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22.
If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that
none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

On Fri, 24 Aug 2007 11:22:01 -0700, DaS wrote:

That did it Ron, thank you very much!

"DaS" wrote:

I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following format
from another post, but all i get is the very last number meaning that none of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?


Glad to help
--ron

IF function for multiple variables
 

=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

Just another option:

=MOD(1711668,MAX(WEEKDAY(A1,2),4)*57+121)

--
Dana DeLouis


"DaS" wrote in message
...
=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

A3 actually is a date 1/1/08, but its fromatted to display Tuesday. 172 is
what's input in to the formulated cell, so that tells me it's not
recognizing
a3's cell contents. Sorry about the lack of information previously.

I tried the =IF(A3="Saturday",22,IF(A3="Sunday",75,0)) formula and all it
returned was a -...it was even tried on a cell that displayed Sunday.

Thanks for your help everyone

"T. Valko" wrote:

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text
of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22.
If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that
none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?

IF function for multiple variables
 

If A3 is a date, IF(a3="Saturday",... won't work. You could try
IF(TEXT(A3,"dddd")="Saturday",...
--
David Biddulph

"Dana DeLouis" wrote in message
...
=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

Just another option:

=MOD(1711668,MAX(WEEKDAY(A1,2),4)*57+121)

--
Dana DeLouis


"DaS" wrote in message
...
=if(a3="Saturday",420,if(a3="sunday",348,if(a3="fr iday",378,172)))

A3 actually is a date 1/1/08, but its fromatted to display Tuesday. 172
is
what's input in to the formulated cell, so that tells me it's not
recognizing
a3's cell contents. Sorry about the lack of information previously.

I tried the =IF(A3="Saturday",22,IF(A3="Sunday",75,0)) formula and all it
returned was a -...it was even tried on a cell that displayed Sunday.

Thanks for your help everyone

"T. Valko" wrote:

What should happen if A3 is neither Sat nor Sun?

Try something like this:

=IF(A3="Saturday",22,IF(A3="Sunday",75,0))

0 means A3 is neither Sat nor Sun.

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
I am trying to make a cell equal a specific number based upon the text
of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22.
If
it's Sunday then I want G3 to be 75. I've tried using the following
format
from another post, but all i get is the very last number meaning that
none
of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?