| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiply if function
Hi,
You may also try this. In range B26:B28, type 0,30,41. In range C26:C28, type 1.25,1,0.17. Now type 28.4 in cell B31. In cell C31, enter the formula =VLOOKUP(B31,B26:C28,2) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "lbreger" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STEP MULTIPLY FUNCTION | Excel Worksheet Functions | |||
| What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
| What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
| keep leading zeros when using the paste spec. multiply function | Excel Discussion (Misc queries) | |||
| is there a function that will multiply different cells | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
