Solved How do I write this IF formula?

June 13, 2013 at 05:41:18
Specs: Windows 7
If cell is < 50,000,000, then return 3. If not, then return 2.

=IF(C24<"$50,000,000$", 3,2)?????
I seem to have it backwards.

See More: How do I write this IF formula?

Report •

June 13, 2013 at 07:10:17
✔ Best Answer
Try just using this:


Law of Logical Argument: Anything is possible if you don't know what you're talking about.

Report •

June 13, 2013 at 08:11:35
When posting in a help forum such as, please use a subject line that is relevant to the contents of your post.

If everyone used a generic subject such "How do I write this formulaā€¯ we wouldn't be able to tell one question from another.

I have edited your subject line to make it more relevant.

Office Forum Moderator

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

Report •

Related Solutions

Ask Question