Thread: Multiple If Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
natei6[_2_] natei6[_2_] is offline
external usenet poster
  
Posts: 1
Default Multiple If Formula
Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",I
A1=7,"21.000",If A1=8,"24.000",I
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",I
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help muc
appreciated.

Nathan Sargean

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote