View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
InspectorPaul InspectorPaul is offline
external usenet poster
 
Posts: 1
Default I need a conditional formula

If the total of a cell is any decimal part more than the whole number (
Example 1.01 raise it to the next whole number 2) and then multiply by a
known number.

Answer 1.01 now becomes 2 X 50