im new to excel and trying to increase my skills need some guidance in Excel IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-1532123%22%20slang%3D%22en-US%22%3Eim%20new%20to%20excel%20and%20trying%20to%20increase%20my%20skills%20need%20some%20guidance%20in%20Excel%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532123%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20write%20a%20formula%20in%20an%20excel%20IF%20function%20and%20am%20not%20sure%20of%20the%20order%20of%20operations%20it%20should%20be%20listed.%20This%20is%20the%20problem%20each%20employee%20is%20given%20a%20weekly%20aptitude%20test%2C%20a%20score%20of%2080%20or%20better%20entitles%20them%20to%20a%20bonus%20of%2015%25%20lower%20than%2080%20gets%20them%200.%20I%20have%20my%20percentage%20listed%20in%20cell%20B22%20in%20excel%20and%20the%20bonus%20a%20percentage%20of%20their%20gross%20pay.%20I%20need%20to%20use%20an%20excel%20IF%20function%20%24794.%20Once%20I%20compute%20the%20first%20bonus%20then%20I%20know%20I%20can%20copy%20the%20formula%20down%20the%20columns%20to%20the%20rest%20of%20the%20employees.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1532123%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532149%22%20slang%3D%22en-US%22%3ERe%3A%20im%20new%20to%20excel%20and%20trying%20to%20increase%20my%20skills%20need%20some%20guidance%20in%20Excel%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532149%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAttaching%20a%20sample%20Excel%20file%20could%20have%20been%20much%20better%20for%20clarify.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20you%20can%20watch%20the%20short%20video%20tutorials%20to%20guide%20you%20on%20how%20to%20use%20the%20IF%20function%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DZs9NuYw-F7k%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DZs9NuYw-F7k%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DKkTaQ5OjAGc%26amp%3Bt%3D604s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DKkTaQ5OjAGc%26amp%3Bt%3D604s%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to write a formula in an excel IF function and am not sure of the order of operations it should be listed. This is the problem each employee is given a weekly aptitude test, a score of 80 or better entitles them to a bonus of 15% lower than 80 gets them 0. I have my percentage listed in cell B22 in excel and the bonus a percentage of their gross pay. I need to use an excel IF function $794. Once I compute the first bonus then I know I can copy the formula down the columns to the rest of the employees.

1 Reply
Hello,

Attaching a sample Excel file could have been much better for clarify.

However, you can watch the short video tutorials to guide you on how to use the IF function

https://m.youtube.com/watch?v=Zs9NuYw-F7k

https://m.youtube.com/watch?v=KkTaQ5OjAGc&t=604s