Posted to microsoft.public.excel.newusers

Dave in Ampthill[_2_] Dave in Ampthill[_2_] is offline

external usenet poster

Posts: 10

IF statements

I wish to add the following formula in a cell:

IF D6<1981 then C41=E22

C41 is the cell I wish to put the data in. How should this be written?

Many thanks

Dave

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
If, then statements	sarahz11	Excel Discussion (Misc queries)	4	March 20th 07 06:46 PM
If then statements	Emily	Excel Discussion (Misc queries)	3	March 20th 07 04:48 PM
If, Then Statements	RS	Excel Worksheet Functions	0	November 30th 06 05:38 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
if statements	tom	Excel Discussion (Misc queries)	3	November 18th 05 09:32 AM

All times are GMT +1. The time now is 06:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us