need help with a forumula

		Microsoft Office Forums > Microsoft Excel > Excel
need help with a forumula

FAQ

Thread Tools

Display Modes

11-07-2008, 03:15 PM

phroche

Windows XP need help with a forumula

Office 2003

Novice

Join Date: Nov 2008

Posts: 2

I think this will help

if(a1=0,b1,if a1=1,b1-(b1*.25),if a1=2,b1-(b1*.50),if a1=3,b1-(b1*.75),0)
bonus=100
error = 0 bonus = 100
error = 1 bonus = 75
error = 2 bonus = 50

error = 3 bonus = 25
error > 3 bonus = 0

You can on do 7 layers of nesting.

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 PM.