Solved for 2010 nested if

September 25, 2013 at 13:53:30
Specs: Windows 7
need an example of a nested if statement where if a1 is greater than 1 but below 10 we show 1 but if a1 is greater than 10 but less than 20 end

See More: for 2010 nested if

September 25, 2013 at 16:22:16
✔ Best Answer
This sounds like a homework problem. Have you tried anything on your own?

BTW...what do you mean by "end"?

In any case, perhaps this explanation will get you started...

An IF statement has this syntax:

=IF(logical_test, value_if_true, value_if_false)

A Nested IF is an IF statement where the value_if_false is another IF statement:

=IF(logical_test, value_if_true, IF(logical_test, value_if_true, value_if_false), etc.)

An AND statement compares multiple arguments and returns TRUE only when all arguments are TRUE.

Try an AND statement as your logical_test and see what happens.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question