Thread: if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ann ann is offline
external usenet poster
 
Posts: 210
Default if formula

how do i get this logic to work. if x30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21