Home

Help with IF function. Please help!

%3CLINGO-SUB%20id%3D%22lingo-sub-251402%22%20slang%3D%22en-US%22%3EHelp%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251402%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20this%20should%20be%20easy%20but%20we%20had%20no%20help%20at%20all%20with%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20instructions%20for%20this%20step%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Insert%20an%20IF%20function%20in%20cell%20E5%20to%20calculate%20the%20total%20due.%20If%20the%20student%20has%20chosen%20to%20personalize%20the%20ring%2C%20there%20is%20an%20additional%20charge%20of%205%25%20located%20in%20cell%20%3CSTRONG%3EB21%3C%2FSTRONG%3E%20that%20must%20be%20applied%3B%20if%20not%2C%20the%20student%20only%20pays%20the%20base%20price.%20Use%20appropriate%20relative%20and%20absolute%20cell%20references.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-251402%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eassignments%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ehelp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIF%20function%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251430%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251430%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20simple%20maths.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20do%20you%20add%205%25%20to%20a%20number%3F%20Either%20use%20%3CSTRONG%3Enumber%20%2B%20(number%20*%200.05)%20%3C%2FSTRONG%3Eor%2C%20shorter%2C%20use%3CSTRONG%3E%20number*1.05%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251413%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251413%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Erin%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20more%20question.%26nbsp%3B%3CSPAN%3E%3DIF((D5%3D%22Yes%22)%2C(C4*1.05)%2CC4)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhy%20did%20you%20add%20the%201.05%3F%20I%20can%20understand%20it%20all%2C%20but%20what%20is%20the%201%20for%3F%20.05%20is%20the%20percentage.%20Why%20the%201%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251411%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251411%22%20slang%3D%22en-US%22%3E%3CP%3EI%20added%20C5%20instead%20of%20C4!!!%20It%20worked!%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251410%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20thanks%20for%20the%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20what%20you%20said%20and%20it%20came%20up%20with%20a%20%23Value!%20error.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251404%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function.%20Please%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251404%22%20slang%3D%22en-US%22%3E%3CP%3ETry%3A%3C%2FP%3E%3CP%3E%3DIF((D5%3D%22Yes%22)%2C(C4*1.05)%2CC4)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I know this should be easy but we had no help at all with this. 

 

Here are the instructions for this step:

 

"Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references."

 

Thanks

5 Replies
Highlighted

Try:

=IF((D5="Yes"),(C4*1.05),C4)

Highlighted

Hi thanks for the help. 

 

I did what you said and it came up with a #Value! error. 

Highlighted

I added C5 instead of C4!!! It worked! Thank you!

Highlighted

Hi Erin,

 

One more question. =IF((D5="Yes"),(C4*1.05),C4)

 

Why did you add the 1.05? I can understand it all, but what is the 1 for? .05 is the percentage. Why the 1?

Highlighted

That's simple maths. 

 

How do you add 5% to a number? Either use number + (number * 0.05) or, shorter, use number*1.05

Related Conversations
Need some help figuring out edge://sync-internals/
HotCakeX in Discussions on
0 Replies
Notifications from Planner in Teams
nwehl in Microsoft Teams on
0 Replies
Embedded Sharepoint List - Custom Forms not loading
sbayer in Microsoft Teams on
0 Replies
Adding Wiki Tab Issue
goatscandrum in Microsoft Teams on
1 Replies
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies