SOLVED

IF query

%3CLINGO-SUB%20id%3D%22lingo-sub-795260%22%20slang%3D%22en-US%22%3EIF%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795260%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20have%20a%20query%20where%20IF%20there%20is%20text%20entered%20into%20Country%20then%20invoice%20totals%20value%20will%20be%20overwritten%20and%20populated%20with%20sell%20prices%20value.%3C%2FP%3E%3CP%3EMore%20details%20within%20my%20Excel%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-795260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795297%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388450%22%20target%3D%22_blank%22%3E%40G00dman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20in%20B2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(ISBLANK(%5B%40Country%5D)%2CSUM(%5B%40%5BSell%20Price%5D%5D*1.2)%2C%5B%40%5BSell%20Price%5D%5D)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795299%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emany%20thanks%20this%20has%20worked%20perfectly%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795310%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795310%22%20slang%3D%22en-US%22%3EYou%20are%20welcome%3C%2FLINGO-BODY%3E
G00dman
New Contributor

Hi,

 

I am looking to have a query where IF there is text entered into Country then invoice totals value will be overwritten and populated with sell prices value.

More details within my Excel sheet.

3 Replies
Solution

Hi @G00dman 

 

Try this in B2

 

=IF(ISBLANK([@Country]),SUM([@[Sell Price]]*1.2),[@[Sell Price]])

@tauqeeracma 

many thanks this has worked perfectly

You are welcome
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies