How about this formula. How do I prevent the amount from showing all the way down the column so I can use the sum function at the bottom of the column as I fill out this column throughout the month?
=IF(I2=8.5,0,(8.5-I2)/.05*15)
How about this formula. How do I prevent the amount from showing all the way down the column so I can use the sum function at the bottom of the column as I fill out this column throughout the month?
=IF(I2=8.5,0,(8.5-I2)/.05*15)
Maybe this...
=IF(I2="","",IF(I2=8.5,0,(8.5-I2)/0.05*15))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks