Thread: Need help with formula please
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Need help with formula please
Put this formula in D3...

=IF(C2<2,10,IF(C2<7,15,IF(C2<15,20,IF(C2<25,25,30) )))

Damn! Change the C2's above to C3's.


and copy down.

Rick

Reply With QuoteReply With Quote