Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to create a function that will subtract, but if the answer is
less than zero, will put a zero in the cell. I don't know how to do this. Can you help me? |
#2
![]() |
|||
|
|||
![]()
Try this
=IF(A1-A2<0,0,A1-A2) with A1 & A2 being any cells "Tina" wrote: I am trying to create a function that will subtract, but if the answer is less than zero, will put a zero in the cell. I don't know how to do this. Can you help me? |
#3
![]() |
|||
|
|||
![]()
Hi
You could try wrapping your formula in a MAX function: =MAX(yourfunction,0) -- Andy. "Tina" wrote in message ... I am trying to create a function that will subtract, but if the answer is less than zero, will put a zero in the cell. I don't know how to do this. Can you help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Paste a function as a fixed number | Excel Discussion (Misc queries) | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |