Posted to microsoft.public.excel.misc

nick

external usenet poster

Posts: 192

Help with nested if/or statements

Hi,
I'm trying to construct a formula that does the following
=IF(AND(OR(ISTEXT(Sheet3!$A$28),ISNUMBER(Sheet3!$A $28))),OR(ISTEXT(Sheet3!A$30),ISNUMBER(Sheet3!A$30 ),Sheet3!C30,Sheet3!C28),Sheet3!C25)

In plain talk, if there is text or numbers in A28, check if there is text or
numbers in A30, if no in the first IF use c25, if no in the second arguement
use c28, if yes for both use c30

Any ideas?

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
Nested IF statements	Karrisac15	New Users to Excel	1	July 19th 07 08:06 PM
Nested IF statements	TwoDot	Excel Worksheet Functions	4	February 8th 07 12:17 AM
I want to use more than 7 nested if then statements	IF I only had a brain for IF statements	Excel Worksheet Functions	11	August 9th 05 01:28 AM
Nested IF statements	John Simons	Excel Worksheet Functions	14	February 16th 05 06:17 AM
Do I need nested IF statements?	Jaramya	Excel Worksheet Functions	1	November 5th 04 09:10 PM

All times are GMT +1. The time now is 11:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us