Solved nested IF formula with multiple variables

June 24, 2013 at 09:50:16
Specs: Windows 7
Could some one write the formula for the problem opposite as I have the same problem. Much appreciated.

Example below. C8 is not a formula, but a direct entry.

=IF(C8 >50000000, 3)
OR IF (C8.25000000,2) OR IF (C8 .5000000, 1)

Where is the error?

See More: nested IF formula with multiple variables

Report •

June 24, 2013 at 11:05:37
✔ Best Answer
First, are your "dots" (.) supposed to be greater than signs?

If so, then this is what I think you are looking for:


Keep in mind that each IF has to have a value_if_true and a value_if_false argument. Your 3, 2 and 1 are your value_if_true arguments and the 2nd and 3rd IF's are the value_if_false for the preceeding IF's.

However, you don't have a value_if_false for IF(C8>5000000...) so any C8 value less than 5000000 will return FALSE since that is the default.

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

Report •
Related Solutions

Ask Question