Thread: need to subtract .50 from a cell if it is over 6.00
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Brown Jeff Brown is offline
external usenet poster
  
Posts: 4
Default need to subtract .50 from a cell if it is over 6.00
Here is the formula it works but I need it to also subtract .50 from I5 if I5
is greater then 6.00 after it is divided by 24 at the end, it is for a time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))
Reply With QuoteReply With Quote