| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two functions in one formula.
I need this formula, using Excel 2003.
Here I want that when A3 is < than A1, answer becomes in cell A2 and in the same formula when A3 is than A1, answer in A2 becomes 0. Example: A1 A2 A3 100 20 80 100 0 140 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two functions in one formula.
Hi Max
Try this function :=IF(C1<A1,A1-C1,0) HTH John "MAX" wrote in message ... I need this formula, using Excel 2003. Here I want that when A3 is < than A1, answer becomes in cell A2 and in the same formula when A3 is than A1, answer in A2 becomes 0. Example: A1 A2 A3 100 20 80 100 0 140 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two functions in one formula.
.... or =MAX(A1-C1,0)
-- David Biddulph "John" wrote in message ... Hi Max Try this function :=IF(C1<A1,A1-C1,0) HTH John "MAX" wrote in message ... I need this formula, using Excel 2003. Here I want that when A3 is < than A1, answer becomes in cell A2 and in the same formula when A3 is than A1, answer in A2 becomes 0. Example: A1 A2 A3 100 20 80 100 0 140 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add several functions in one formula | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| 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
