| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What does ABS mean in front of a Formula
Hi all, Have a question am absolute puzzelled. The below formula has ABS after =. The formula just caclulates a ratio thou when you do it without ABS in front the Ratio is negative eg: -19, thou when you put ABS in front it rides the Negative eg: 19. Why does it do this & what does ABS mean. WOULD APPRECIATE ALL THE HELP AM AGAIN CONFUSSED I NEED A HOLIDAY. Cheers Will =ABS(C36/B36) -- william4444 ------------------------------------------------------------------------ william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991 View this thread: http://www.excelforum.com/showthread...hreadid=537570 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
