View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ken-hup ken-hup is offline
external usenet poster
 
Posts: 5
Default entering multiple command formulas

Try this
=IF((A2A1),0,IF(((A1-A2)/2)<0,0,A1-A2/2))

This will result in required answer or 0

"lilprintesa1028" wrote:

I need to enter a formula that will subtract two cells without getting a
negative, then divide that number by 2. Any suggestions?