Antonio Mora

Posts: n/a

How do I put more than 7 IF formula in a single cell?

There is a maximum set up for how many IF functions can be directly in a row
in a cell. My example:
=IF(AND(B450,B45<1000,1,IF(AND(B451000,B45<3000, 2,IF.... I would like to
continue this out to about 40, is this possible? or can I use some other
formula to make this work correctly?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Condition Sumif Formula	momtoaj	Excel Worksheet Functions	3	April 6th 05 04:06 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
looking for a formula	Amanda	Excel Worksheet Functions	5	January 5th 05 07:37 AM
Help with macro formula and variable	Huge project	Excel Worksheet Functions	0	December 28th 04 01:27 AM
Formula Result Correct but value in the cell is wrong	jac	Excel Worksheet Functions	2	December 17th 04 08:05 PM

All times are GMT +1. The time now is 09:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us