Excel 2007 : multiple actions in IF statement when true

**nlm** · 10-12-2011, 12:40 AM

Hi,

I want to perform two different actions when an IF statement true like if statement true then I have to compute two values and insert "TRUE" in another column.

Any help would be appreciated.

thanks,

**abousetta** · 10-12-2011, 12:51 AM

Sorry. Could you elaborate further because I can't understand what you want to do?

abousetta

**nlm** · 10-12-2011, 06:13 AM

A B C D
1 14 TRUE 14
2 4 TRUE 8

My condition is if cell A content is less than cell B, then it display TRUE in C and multiply both numbers in cell D.

Hope I make it clear.

Thanks.

**abousetta** · 10-12-2011, 06:48 AM

For the first part (Column C), there are two ways you can go about this. If you only want True and False then:

Please Login or Register  to view this content.

This will return True or False

or

Please Login or Register  to view this content.

As for Column D, you didn't say what to do if the argument is false so I will assume that you want a blank.

Please Login or Register  to view this content.

Hope this helps.

abousetta

**nlm** · 10-13-2011, 02:58 AM

Thanks abousetta!

Actually i was thinking of doing multiple tasks with one IF statement which I think not possible.

Anywayz thanks for your help!

**Nikeyg** · 10-13-2011, 05:39 AM

Originally Posted by nlm

Thanks abousetta!

Actually i was thinking of doing multiple tasks with one IF statement which I think not possible.

Anywayz thanks for your help!

You could just put the formula for cell D in cell C

Please Login or Register  to view this content.

Then, instead of "", put "FALSE" instead.
You wont get your 'TRUE' reader, but, if it's good, you will get the correct figure in C, and if not, it will report FALSE, or whatever you want it to say.