SOLVED
Home

Help with my formula

%3CLINGO-SUB%20id%3D%22lingo-sub-401135%22%20slang%3D%22en-US%22%3EHelp%20with%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401135%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EI%20need%20help%20correcting%20this%20formula.%20In%20cell%20E4%2C%20I%20wish%20to%20show%2050%25%20of%20the%20value%20from%20C4%20if%20D4%20has%20the%20word%20YES.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20assistance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20386px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F105993i7733538BA7998EFE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20snipit.PNG%22%20title%3D%22excel%20snipit.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401168%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401168%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(D4%3D%22yes%22%2CC4*50%25%2C0)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20will%20return%2050%25%20of%20the%20value%20of%20cell%20C4%20when%20the%20value%20of%20D4%20is%20%3CSTRONG%3Eyes%3C%2FSTRONG%3E%2C%20otherwise%20it%20will%20return%20%3CSTRONG%3E0%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315113%22%20target%3D%22_blank%22%3E%40noelosborne1%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401167%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401167%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20want%20to%20be%20shown%20in%20E4%20if%20D4%20is%20%E2%80%9CNo%E2%80%9D%20or%20Blank%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-403428%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-403428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%20It%20worked%20out%20how%20I%20wanted%20and%20has%20allowed%20me%20to%20learn%20a%20little.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENoel%3C%2FP%3E%3C%2FLINGO-BODY%3E
noelosborne1
New Contributor

Hello all,

I need help correcting this formula. In cell E4, I wish to show 50% of the value from C4 if D4 has the word YES. 

Thanks for your assistance.

 

excel snipit.PNG

3 Replies
What do you want to be shown in E4 if D4 is “No” or Blank?
Solution

Hi,

 

Try this formula:

=IF(D4="yes",C4*50%,0)

 

It will return 50% of the value of cell C4 when the value of D4 is yes, otherwise it will return 0.

 

Hope that helps

 

@noelosborne1

@Haytham Amairah 

 

Thank you for your help. It worked out how I wanted and has allowed me to learn a little.

 

Noel

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies