Help w/formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If column A is 1000 and column B is 500, result is shown as $ amount. But, reversing the numbers, same result neede
Exampl
Employee costs are 210, income for that day is 100. New cell gives $ difference. The next day employee costs are 210 but income is 100, needed difference again, without having to make it a simple add or subtract fomula and having to format each cell - enter and it knows if income is higher or lower than expenses
 
Hi
try
=ABS(A1-B1)

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff whelan said:
If column A is 1000 and column B is 500, result is shown as $ amount.
Click to expand...
But, reversing the numbers, same result needed
Example
Employee costs are 210, income for that day is 100. New cell gives $
Click to expand...
difference. The next day employee costs are 210 but income is 100,
needed difference again, without having to make it a simple add or
subtract fomula and having to format each cell - enter and it knows if
income is higher or lower than expenses
 
Back
Top