Thread: Need help!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default Need help!


ed wrote:
Your formula is now:
IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))
Change it to:
IF(G4A4,"overspent",IF(AND(B4<A4,C43),"ok"),"pro blem"))

Whoops delete the ) after "ok" so formula should be:

=IF(G4A4,"overspent",IF(AND(B4<A4,C43),"ok","pro blem"))

sorry, ed