Posted to microsoft.public.excel.programming

external usenet poster

Posts: 9

prob in IF then else statement

I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK
worksheet, heres my formula in cell C8
=IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if DEADLOAD!A20
is blank and A21(A21 instead of A20) has a value, and I want the result to be
on cell C8.. and if A21 is followed with a value at A22, I want the result to
be on cell C9.. Hope you get what I mean... thanks....

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
CSE Formula Prob	pdberger	Excel Worksheet Functions	4	February 16th 08 03:51 AM
Concatenation prob	Dick Kusleika[_4_]	Excel Programming	0	September 19th 07 10:41 PM
Personal.XLS Prob.	Dave Birley	Excel Programming	2	July 9th 07 03:36 PM
A little help, prob simple to anyone else	john_w100	New Users to Excel	5	June 17th 05 01:47 PM
if function prob	Manisha[_2_]	Excel Programming	2	April 23rd 04 03:46 PM

All times are GMT +1. The time now is 02:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us