Thread: IF Statements - Novice
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default IF Statements - Novice
=IF(N95=0,0,IF(N95<=3,90,N95*30))

or even better

=IF(N95=0,0,IF(AND(N95<=3,90,N950),90,N95*30))
Reply With QuoteReply With Quote