Thread: Calculating with some rules
View Single Post
  #3  
Old 01-09-2009, 06:34 PM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,543
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Or =IF(A1 = 0, "", MAX(A1, 0.42) * B1 * (1 + 35% * (A1 > 3.2) + 10% * (A1 > 4.2) ) )
__________________
Entia non sunt multiplicanda sine necessitate.
Last edited by shg; 01-09-2009 at 06:37 PM.
Reply With Quote