Thread: [Solved] Range Formula
View Single Post
 
Old 05-16-2009, 05:42 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Yup - all you need to do is alter zyzzyva57's formula in B12 to:

Code:
=IF(B10>20000,(IF(B10>50000,30000*H11,(B10-20000)*H11)),"")
If you want the cells to show nothing in them if there is no value, then change the 0 at the end of the formula in B13 to "" as in the code above.
If you want the cells to show $0.00 in them if there is no value, then change the "" at the end of the formula above to 0.
Reply With Quote