Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Formulas
These three formulas need to be combined into a single formula:
1.) =IF(D7E7,D7*H7) D7 greater than E7 Or (could these two be combined?) 2.) =IF(D7=E7,D7*H7) D7 equal to E7 Or 3.) =IF(D7<E7,((D7-E7)+(D7*H7))) D7 less than E7 Then the single formula will be used (copied) into the 90 rows below row 7. Would this be better done with VBA in a module? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Formulas
Phil,
=IF(D7=E7,D7*H7,(D7-E7)+(D7*H7)) NickHK "Phil H" wrote in message ... These three formulas need to be combined into a single formula: 1.) =IF(D7E7,D7*H7) D7 greater than E7 Or (could these two be combined?) 2.) =IF(D7=E7,D7*H7) D7 equal to E7 Or 3.) =IF(D7<E7,((D7-E7)+(D7*H7))) D7 less than E7 Then the single formula will be used (copied) into the 90 rows below row 7. Would this be better done with VBA in a module? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Formulas
Phil H wrote: These three formulas need to be combined into a single formula: 1.) =IF(D7E7,D7*H7) D7 greater than E7 Or (could these two be combined?) 2.) =IF(D7=E7,D7*H7) D7 equal to E7 Or 3.) =IF(D7<E7,((D7-E7)+(D7*H7))) D7 less than E7 Then the single formula will be used (copied) into the 90 rows below row 7. Would this be better done with VBA in a module? VBA is not necessary, I think: =D7*H7+MIN(D7-E7,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Help with combining 2 formulas | Excel Discussion (Misc queries) | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Combining two formulas | Excel Worksheet Functions | |||
Combining formulas | Excel Discussion (Misc queries) |