Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Tad harsh don't you think?
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ardus Petus" wrote in message ... The author of the workbook you received is a pervert. :-) -- AP a écrit dans le message de news: ... I recently received a spreadsheet that contained =sum(a1/a2)-1+1. The cell containing the formula was formatted to percentage. I was wondering why use =sum()-1+1 when +a1/a2 would render the same result (provided the cell is formatted to percentage)? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
Percentage Calculation | Excel Worksheet Functions | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) |