Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display totals only over a certain amount
Hi:
I have a worksheet that totals colums for a daily payroll total for a company. The 1st and 2nd colum need to be entered daily from a different spreadsheet, the 3rd colum will already have an amount (salary amount) and that colum is hidden and protected. However, I do not want the total to show up if the user enters "0" in column 1 and 2 because they would be privy to the salary amount - so is there a way in excel I can have the spreadsheet only display a total if it is over a certain amount? This way the salary would be protected and the amount would only show for example if it is over $500. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highly Complex Totals of Data | Excel Discussion (Misc queries) | |||
Need help with custom sorting | Excel Discussion (Misc queries) | |||
Formula needed to create grand totals | Excel Worksheet Functions | |||
Amount Spent vs Budget | Excel Discussion (Misc queries) | |||
Filtering and Totals | Excel Discussion (Misc queries) |