Is there any way to have multiple actions when using an IF statement?
I want to say, =IF(something is true,do this and do this,else do something else)
Many thanks
Is there any way to have multiple actions when using an IF statement?
I want to say, =IF(something is true,do this and do this,else do something else)
Many thanks
The IF statement will only affect the value in the cell it is in. Can you be more specific?
For example, if the value in A1 is greater than the value in A2, then multiply the value in A2 times 10 and add 3. If not, return the value in A1 would look like this
=IF(A1>A2, A2*10-3, A1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Okay, I think I answered my own question using a nested IF!
=IF(something is true,IF(someting is true,do this,and do this,""),else do something else)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks