Microsoft Office Forums - View Single Post - need help with a forumula

Thread: need help with a forumula

View Single Post

Old

11-07-2008, 03:15 PM

phroche

phroche is offline

phroche uses Windows XP

Windows XP phroche uses Office 2003

phroche uses Office 2003

Office 2003

Novice

Join Date: Nov 2008

Posts: 2

phroche is on a distinguished road

Default

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.

Reply With Quote