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 •


#1
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:

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

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