View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chelledc chelledc is offline
external usenet poster
 
Posts: 3
Default Product - Conditions - Edited Results

I have the following.....

A B
1 ?????? Sum=(A1)*(-15%)+A1 To get net figure for
sales

Example
18,358.00 15,604.30

How do I get the answer in B to round up or remove the change?

Any help would be appreciated.

Thanks,