Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
If you want positive numbers, then just =ABS(SUM($H$5:H6)+(B4))
************ Anne Troy www.OfficeArticles.com "Niagera College Student" wrote in message ... I need a formula what will tun a positive number in to a negiive. =SUM($H$5:H6)+(B4) B4 is a negitive number and so my anser apears negitive, but I would like it to apear possitive by adding to the formula not my chainfg any of my numbers in to a positive. Can this be done ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort ignoring negatives and positives | Excel Worksheet Functions |