Discussion Re: If functions in Excel
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574015#M107674
Hi Riny<BR />A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.<BR /><BR />Example:<BR />Blue + Yellow is Green, but Blue + Red is purple.Thu, 22 Jul 2021 06:58:16 GMTSofia21652021-07-22T06:58:16ZIf functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2573931#M107669
<P>Looking for a formula that can say 'if A plus B happens take action X, but if A and C instead happens then take action Y'. Is that possible in Excel?</P>Thu, 22 Jul 2021 06:34:32 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2573931#M107669Sofia21652021-07-22T06:34:32ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2573968#M107671
<P><LI-USER uid="1109791"></LI-USER> What do you mean by "happens"? <STRONG>IF</STRONG> A and B contain a certain value, or <STRONG>IF</STRONG> A + B add up to a certain value? Or perhaps IF both A and B are not blank/empty?</P>Thu, 22 Jul 2021 06:37:53 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2573968#M107671Riny_van_Eekelen2021-07-22T06:37:53ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574015#M107674
Hi Riny<BR />A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.<BR /><BR />Example:<BR />Blue + Yellow is Green, but Blue + Red is purple.Thu, 22 Jul 2021 06:58:16 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574015#M107674Sofia21652021-07-22T06:58:16ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574067#M107677
<P><LI-USER uid="1109791"></LI-USER> Still not very clear. If you have an example workbook that demonstrates what you want to achieve, please upload it.</P><P> </P>Thu, 22 Jul 2021 07:19:09 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574067#M107677Riny_van_Eekelen2021-07-22T07:19:09ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574102#M107678
<P><LI-USER uid="1109791"></LI-USER> </P><P> </P><P>Please help me, I'm a little irritated by your request.<BR />You would like to know if A plus B happens take action X, but if A and C instead happens then take action Y '.<BR />What should happen if A plus B and A and C appear at the same time?<BR />Wouldn't it help if only A was searched for a certain value?</P><P> </P><P>Thank you for your patience and time.</P><P> </P><P>Nikolino</P><P>I know I don't know anything (Socrates)</P>Thu, 22 Jul 2021 07:27:35 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574102#M107678NikolinoDE2021-07-22T07:27:35ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574236#M107682
<P><LI-USER uid="1109791"></LI-USER> </P>
<P>Looks like</P>
<LI-CODE lang="excel">=IF( (A="Blue")*(B="Yellow"), "Green", IF( (A="Blue")*(B="Red"), "Purple", "Color is not defined"))</LI-CODE>Thu, 22 Jul 2021 08:34:52 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574236#M107682Sergei Baklan2021-07-22T08:34:52ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574553#M107692
<P><LI-USER uid="1109791"></LI-USER> </P><P> </P><P>If you want to control values in A, B and C then this would be a simple solution.</P><P>Example in the inserted file</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IF_A_B_C.JPG" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/297606i77502344CC3DB829/image-size/large?v=v2&px=999" role="button" title="IF_A_B_C.JPG" alt="IF_A_B_C.JPG" /></span></P><P> </P><P>Thank you for your patience and time.</P><P> </P><P>Nikolino</P><P>I know I don't know anything (Socrates)</P>Thu, 22 Jul 2021 09:50:59 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2574553#M107692NikolinoDE2021-07-22T09:50:59ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2575243#M107711
<P><LI-USER uid="403176"></LI-USER><BR /><BR />What i'm trying to do is a form of risk assessment/analysis. But rather than a matrix, I was looking to have input fields (likely from a drop-down) for risk and likelyhood and then a show the consequence and severity if it were to happen.<BR /><BR /></P>Thu, 22 Jul 2021 13:05:40 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2575243#M107711Sofia21652021-07-22T13:05:40ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2575278#M107716
<P><LI-USER uid="1109791"></LI-USER> Sorry for being slow, but can you explain how the matrix relates to your very first post <EM>"</EM><SPAN><EM>if A plus B happens take action X" </EM>?</SPAN></P><P> </P>Thu, 22 Jul 2021 13:24:28 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2575278#M107716Riny_van_Eekelen2021-07-22T13:24:28ZRe: If functions
https://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2578011#M107819
IF(AND(A=TRUE,B=TRUE), DoThisAction, DoThatAction)<BR />IF(AND(A=5,B=5), x*y, x-y)Fri, 23 Jul 2021 04:11:13 GMThttps://techcommunity.microsoft.com/t5/excel/if-functions/m-p/2578011#M107819Yea_So2021-07-23T04:11:13Z