Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Brown[_2_] Jeff Brown[_2_] is offline
external usenet poster
  
Posts: 1
Default formula help
I have a formula and can not make it work the way I would like.
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is.
I need it to subtract .50 from I5 if I5 is greater then 6.00
Reply With QuoteReply With Quote