LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Using Formulae in If statements

Hi all,

I'm trying to set up some spreadsheet exercises for some students who are
studying Excel at an intermediate level.

One of the problems that they have to solve involves entering an IF statement
in cells F3 through to F10

What I want to do is to have the adjoining cells (G3 - G10) show Correct or
Try again, depending on whether the formula they have used is right. Is there
a way of entering the formula required into the logical argument of an IF
statement in cells G3 - G10?

Thanks,

Tazzy

--
Message posted via http://www.officekb.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
formulae Gerald New Users to Excel 2 May 8th 06 09:23 PM
If Statements - Multiple formulae Ms MIS Excel Worksheet Functions 6 December 8th 05 05:49 PM
Formulae k f h Excel Worksheet Functions 6 July 19th 05 09:58 AM
Searching TEXT in formulae, rather than results of formulae AndyE Excel Worksheet Functions 1 July 15th 05 10:57 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"