| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two functions in one formula.
I need this formula, using Excel 2003.
Example: A1 A2 A3 100 20 80 (Here I want that when A3 is < than A1, answer becomes 100 0 140 in cell A2 and in the same formula when A3 is than A1, answer in A2 becomes 0). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two functions in one formula.
See your other post in -excel.misc-
"MAX" wrote in message ... I need this formula, using Excel 2003. Example: A1 A2 A3 100 20 80 (Here I want that when A3 is < than A1, answer becomes 100 0 140 in cell A2 and in the same formula when A3 is than A1, answer in A2 becomes 0). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| If/Or Formula Functions | Excel Discussion (Misc queries) | |||
| Using the AND and OR functions in the same formula | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Linear Mode
