Posted to microsoft.public.excel.misc

Drew[_2_]

external usenet poster

Posts: 22

When IF has limited iterations

Hello everyone.

I am wanting to use the following IF formula and it only covers 8 out of 12
cells in a row that I need to extract data from.

=IF(F4=F10,E4,IF(G4=F10,E4,IF(H4=F10,E4,IF(I4=F10, E4,IF(J4=F10,E4,IF(K4=F10,E4,IF(L4=F10,E4,IF(M4=F1 0,E4,"-"))))))))

There has to be a better way. Help please.

Thank you. Drew.

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
iterations?	Dave O.	Excel Worksheet Functions	2	October 23rd 07 12:26 AM
How many iterations it takes to get to 0?	Rick	Excel Worksheet Functions	12	May 10th 07 10:46 PM
# of iterations	Rick	Excel Worksheet Functions	1	May 10th 07 04:41 PM
Iterations	antonje	New Users to Excel	2	October 10th 06 08:11 PM
Is there a way where I can default iterations	Kelseyk	Excel Discussion (Misc queries)	0	March 28th 06 12:49 AM

All times are GMT +1. The time now is 12:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us