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 13 posts 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 Specs
 .
 06 Jan 2019 #2 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,744 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping 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 Specs
 06 Jan 2019 #3 goshenBleeping Windows 7 Home Premium 64bit 13 posts 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 Specs
 .
 06 Jan 2019 #4 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,744 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping 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 Specs
 06 Jan 2019 #5 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,744 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping 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 Specs