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?

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_trueand avalue_if_falseargument. Your 3, 2 and 1 are yourvalue_if_truearguments and the 2nd and 3rd IF's are thevalue_if_falsefor the preceeding IF's.However, you don't have a

value_if_falsefor 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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History