Thread: Cant get my head around this one
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mbys14932
 
Posts: n/a
Default Cant get my head around this one

Thanks to all, I have managed to solve the problem using the formula
posted by duane. Thanks duane. The only problem is I don't fully
understand the formula, especially the number 4 in it, what does that
do?!

=IF(A1<96,0,IF(A1136,*_4_*+(A1-136)*22/100,(A1-96)*10/100))


--
mbys14932
------------------------------------------------------------------------
mbys14932's Profile: http://www.excelforum.com/member.php...o&userid=34914
View this thread: http://www.excelforum.com/showthread...hreadid=546523

Reply With QuoteReply With Quote