| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel formulas
In J5 I have the following formula
=IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6,"") This is based on selling product "A" in B5. If we sell product "B,C,D,E etc." I would like to add to the formula E5-2.35*D5 to J5. Thanks in advance for your help!!! |
|
#2
|
|||
|
|||
|
if I am reading your statement correctly
=IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6 + if(or(B5="B",B5="C",B5="D",b5="E"),E5-2.35*D5,""),"") would do it. I am not comfortable I know what you want "Dave O." wrote: In J5 I have the following formula =IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6,"") This is based on selling product "A" in B5. If we sell product "B,C,D,E etc." I would like to add to the formula E5-2.35*D5 to J5. Thanks in advance for your help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Linear Mode
