Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel - Multiple actions for each part of IF statement?

05 Jan 2019   #1
goshenBleeping

Windows 7 Home Premium 64bit
 
 
Excel - Multiple actions for each part of IF statement?

How would I accomplish the following in Excel 2010:

IF (A=B, (action 1 & action 2), action 3)

If A=B, execute both action 1 & action 2.
If A not equal B, execute action 3.

Thank you.


My System SpecsSystem Spec
.
06 Jan 2019   #2
Paul Black

7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi goshenBleeping,

Quote   Quote: Originally Posted by goshenBleeping View Post
How would I accomplish the following in Excel 2010:

IF (A=B, (action 1 & action 2), action 3)

If A=B, execute both action 1 & action 2.
If A not equal B, execute action 3.
Without an example of the parameters etc, you should be able to get an idea from this => =IF(A1=A2,(A1*2+A1*3),"x")

I hope this helps!
My System SpecsSystem Spec
06 Jan 2019   #3
goshenBleeping

Windows 7 Home Premium 64bit
 
 

Clearly I did a poor job of explaining my problem. None of the statements below work. Can someone suggest the correct syntax?

I want to do the following:

=IF(A1=2, B3=27, B3=4) ==> this sets cell B3=27 if cell A1=2, else sets cell B3=4: HOW to do this?

Also

=IF(A1=2, B3=27 & B4=16, B3=4)

==> this sets cells B3 and B4 if cell A1 = 2, else set cell B3=4: HOW to do this?
My System SpecsSystem Spec
.

06 Jan 2019   #4
Paul Black

7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi goshenBleeping,

Quote   Quote: Originally Posted by goshenBleeping View Post
I want to do the following:

=IF(A1=2, B3=27, B3=4) ==> this sets cell B3=27 if cell A1=2, else sets cell B3=4: HOW to do this?
=IF(A1=0,"No Figure In A1",IF(A1=2,27,4))

I hope this helps!
My System SpecsSystem Spec
06 Jan 2019   #5
Paul Black

7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi goshenBleeping,

Quote   Quote: Originally Posted by goshenBleeping View Post
Also

=IF(A1=2, B3=27 & B4=16, B3=4)

==> this sets cells B3 and B4 if cell A1 = 2, else set cell B3=4: HOW to do this?
Seeing you are using a formula in cell B3, you cannot adjust cell B3 using another formula because it will give you a circular error!

Your best bet in this situation would be to use a helper column.

I hope this helps!
My System SpecsSystem Spec
Reply

 Excel - Multiple actions for each part of IF statement?




Thread Tools




Similar help and support threads
Thread Forum
excel if statement
we are wanting to see if we can create an if statement in excel. basically, we are looking to create an if statement. in the first picture below, you see we have a "3" under quanity. then you also see the prices as well. we're wanting to do something like this - if "A5" (the quanity) is greater...
Microsoft Office
Multiple actions on power button
Hello, I would like to both log off and hibernate when I press the power button, but Control panel permits only one action. Ideally, I'd like to configure the windows"start" button to do the same. Have you any idea how i could configure my computer to do so? Thanks for your help. Lionel
General Discussion
Irreversible actions in Excel 2010
Hello, For reversing an action, e.g., getting a text in a cell bold, In MS Excel 2010, we simply press ctrl+z or click undo button in the quick access toolbar. It seems that any action is reversible this way! If not, so what actions aren't reversible in Excel?
Microsoft Office
BSOD while playing online game and doing multiple actions
Alright a client based mmorpg game knightonline were open and i was doing my regular things. The BSOD happened. Gathered with BlueScreenView Here the result ================================================== Filename : hal.dll Address In Stack : hal.dll+12a3b From Address ...
BSOD Help and Support
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:47.
Twitter Facebook Google+