Home

EXCEL CONDITIONAL PROBLEM =(IF,true,false)

%3CLINGO-SUB%20id%3D%22lingo-sub-472839%22%20slang%3D%22en-US%22%3EEXCEL%20CONDITIONAL%20PROBLEM%20%3D(IF%2Ctrue%2Cfalse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472839%22%20slang%3D%22en-US%22%3E%3CP%3EI%20ve%20got%20a%20problem%20with%20the%20ecuacion%20%3DIF(condition%3B%20right%3B%20false)%3C%2FP%3E%3CP%3EIf%20i%20write%20the%20condition%20as%20two%20cells%20are%20equal%20(A3%3DB3)%20as%20de%20condition%20for%20being%20true%20o%20false%2C%20if%20there%20are%20empty%20cells%20it%20counts%20like%20it%20compliments%20the%20condition%20so%20i%20get%20the%20right%20answer%20but%20i%20dont%20want%20this%20to%20happen%20i%20want%20to%20have%20an%20empty%20cell.%3C%2FP%3E%3CP%3EWhat%20can%20i%20do%3F%26nbsp%3B%3C%2FP%3E%3CP%3E(**SI%20is%20IF%20in%20spanish)%3C%2FP%3E%3CP%3EPS%20(if%20i%20dont%20explain%20right%20the%20problem%20is%20that%20i%20dont%20want%20the%2010%20by%20deffect%2C%20i%20want%20empty%20space)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20411px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109507i786A2A2735D14396%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PROBLEMO.jpg%22%20title%3D%22PROBLEMO.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-472839%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-472851%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CONDITIONAL%20PROBLEM%20%3D(IF%2Ctrue%2Cfalse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323554%22%20target%3D%22_blank%22%3E%40malaba13%3C%2FA%3E%20%2C%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIF(ISBLANK(B1)*ISBLANK(C1)%2C%22%22%2CIF(B1%3DC1%2C10%2C-5))%3C%2FPRE%3E%0A%3CP%3EI%20attached%20the%20file%2C%20if%20open%20formula%20will%20be%20converted%20in%20your%20locale%20notation%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-474457%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CONDITIONAL%20PROBLEM%20%3D(IF%2Ctrue%2Cfalse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-474457%22%20slang%3D%22en-US%22%3EThank%20you%20really%20much.%20It%20worked!!!%20I%20have%20no%20words%2C%20you%20are%20really%20a%20great%20man%20and%20you%20deserved%20the%20best%20in%20your%20life.%3CBR%20%2F%3ETHANK%20YOU.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-475634%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CONDITIONAL%20PROBLEM%20%3D(IF%2Ctrue%2Cfalse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-475634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323554%22%20target%3D%22_blank%22%3E%40malaba13%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
malaba13
New Contributor

I ve got a problem with the ecuacion =IF(condition; right; false)

If i write the condition as two cells are equal (A3=B3) as de condition for being true o false, if there are empty cells it counts like it compliments the condition so i get the right answer but i dont want this to happen i want to have an empty cell.

What can i do? 

(**SI is IF in spanish)

PS (if i dont explain right the problem is that i dont want the 10 by deffect, i want empty space)

PROBLEMO.jpg

3 Replies

@malaba13 , that could be

=IF(ISBLANK(B1)*ISBLANK(C1),"",IF(B1=C1,10,-5))

I attached the file, if open formula will be converted in your locale notation

 

Thank you really much. It worked!!! I have no words, you are really a great man and you deserved the best in your life.
THANK YOU.

@malaba13 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 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
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies