Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
remove negative from number | Excel Worksheet Functions | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
MROUND on a negative number. | Excel Discussion (Misc queries) | |||
thousand separator as indian style for negative number | Excel Discussion (Misc queries) |