Posted to microsoft.public.excel.worksheet.functions

DAS

external usenet poster

Posts: 26

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 variables-SOS	Ang	Excel Worksheet Functions	3	April 27th 07 08:24 PM
look for a value with multiple variables	Andrea	Excel Discussion (Misc queries)	2	January 18th 07 12:24 PM
Index Match function for multiple linked variables	Bob	Excel Worksheet Functions	13	November 23rd 05 12:56 AM
Index Match function for multiple linked variables	Bob	Excel Worksheet Functions	0	November 22nd 05 02:12 AM
if function multiple variables	cin	Excel Worksheet Functions	2	September 8th 05 09:32 PM

All times are GMT +1. The time now is 01:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us