ExcelBanter - Two functions in one formula.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Two functions in one formula. (https://www.excelbanter.com/excel-discussion-misc-queries/211368-two-functions-one-formula.html)

Max

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

John[_22_]

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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 07:18 PM.