How can I combine two actions if condition is false in Excel?

user_19783947 0
Viewed 35

I need a help with one Excel problem. I have a formula that is testing few conditions and when it is True it works as I want it to. Although, I can't figure out how to make a cell be a particular value but also change a content of the next one if condition is False.

I tried using nested Substitute formula but it only works for the cell that you are in so this wasn't successful.

if-statement excel-formula excel
1 Answers

With ms365, you could try the following:

=IF(<YourCondition>,<Value>,{<Value1>, <Value2>})

This would then spill two values to the right if condition is FALSE and just a single one if condition is TRUE. For example:

enter image description here

Formula in B1:

=IF(A1,"a",{"b","c"})

This can be further expanded into using actual calculations or any sort of statement using CHOOSE(), for example:

enter image description here

Formula in B1:

=IF(A1,D1,CHOOSE({1,2},D1*3,D1*5)

If available the same can be achieved through using HSTACK():

=IF(A1,D1,HSTACK(D1*3,D1*5))
user_97581940
Related