using multiply if function

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

using multiply if function

I need to create a formula using this information.

Lets say cell G3 is an age 28.4
Than I need in another cell
If G3 is <30 = 1.25
30-40 =1.0
40 = .75

Please help

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
STEP MULTIPLY FUNCTION	Mitch Desai	Excel Worksheet Functions	5	January 30th 08 07:44 PM
What function will find and multiply specific values in excel?	paul/bones	Excel Worksheet Functions	1	March 20th 07 09:44 PM
What function will find and multiply specific values in excel?	paul/bones[_2_]	Excel Worksheet Functions	2	March 20th 07 05:33 PM
keep leading zeros when using the paste spec. multiply function	Debi	Excel Discussion (Misc queries)	4	February 22nd 07 05:41 PM
is there a function that will multiply different cells	Huck	Excel Worksheet Functions	4	March 6th 06 08:41 PM

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

Menu

About Us