Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering multiple command formulas
I need to enter a formula that will subtract two cells without getting a
negative, then divide that number by 2. Any suggestions? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering multiple command formulas
Try this
=IF((A2A1),0,IF(((A1-A2)/2)<0,0,A1-A2/2)) This will result in required answer or 0 "lilprintesa1028" wrote: I need to enter a formula that will subtract two cells without getting a negative, then divide that number by 2. Any suggestions? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering multiple command formulas
Does this work for you:
=Abs(A1-B1)/2 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "lilprintesa1028" wrote in message ... I need to enter a formula that will subtract two cells without getting a negative, then divide that number by 2. Any suggestions? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering multiple command formulas
Just to explain -
If A2 is greater than A1 put 0, if A2 is less than A1 try... If A1-A2 divided by 2 is less than 0 put 0, if it is greater than 0 put answer of A1-A2 / 2 Hope this helps you understand "nested" IF statements "ken-hup" wrote: Try this =IF((A2A1),0,IF(((A1-A2)/2)<0,0,A1-A2/2)) This will result in required answer or 0 "lilprintesa1028" wrote: I need to enter a formula that will subtract two cells without getting a negative, then divide that number by 2. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Formulas | Excel Discussion (Misc queries) | |||
Enable Command Button After Entering Text | New Users to Excel | |||
Entering Formulas | Excel Worksheet Functions | |||
Entering formulas | Excel Worksheet Functions | |||
Entering multiple formulas in one cell | Excel Worksheet Functions |