Need Help On IF Formula Plz

**Snooza35** · 10-06-2006, 07:36 AM

Hey Thnx For Helping IN Advance.

I Have Got A Problem I need the information to come up in the cell with nothing but it still keeps coming up with FALSE

The Formula I have Writing in is:

=IF(B2="","")=IF(B2=C2,"correct")

I would have thought this would have been write i have only been using excel for about a week.

Plz Post Back Ty

**starguy** · 10-06-2006, 08:07 AM

Originally Posted by Snooza35

Hey Thnx For Helping IN Advance.

I Have Got A Problem I need the information to come up in the cell with nothing but it still keeps coming up with FALSE

The Formula I have Writing in is:

=IF(B2="","")=IF(B2=C2,"correct")

I would have thought this would have been write i have only been using excel for about a week.

Plz Post Back Ty

try this
=IF(B2=C2,"correct","")

**Snooza35** · 10-09-2006, 08:51 AM

Ok thnx for that it worked fine, now all i need is if the incorrect answer gets typed in wrong then what formula will i need to enter?

=IF(B2=C2,"correct","")

all i need is a formula if the incorrect answer is put into b2 but to still come up with correct and leave the box blank.

thnx for the help starguy :D

Plz Help

**JR@SGC** · 10-09-2006, 08:57 AM

try:

=IF(B2=C2,"correct","Incorrect")

Is this what u are after?

**Snooza35** · 10-09-2006, 09:20 AM

Nah It didnt help abit. Sorry.
Still Looking for the answer its quite hard.

thnx agen for trying Bro.

**kraljb** · 10-09-2006, 03:48 PM

If what you are looking for is a formula to do the following

If B2 is blank then Blank
If B2 is C2 then Correct
If B2 is not blank and not C2 then Incorrect

=if(B2="","",if(B2=C2,"Correct","Incorrect"))

That formula should take care of it...

**AJ100** · 10-10-2006, 06:05 AM

How about you do your own ICT coursework?

Im very disappointed in you Snooza!

Tim Crapnell

**Snooza35** · 10-10-2006, 06:13 AM

Cheers for the help, Ok Now I Need Help My Next Step!

If B2 is blank then Blank
If B2 is C2 then Correct
If B2 is not blank and not C2 then Incorrect

I Need E2 to be 0 and if someone answers a question i need it to go to 1

if d2 is correct or incorrect e2=1
but if it is blank to be 0

btw who is tim?

ty again you help loads

**starguy** · 10-10-2006, 06:31 AM

Originally Posted by Snooza35

Cheers for the help, Ok Now I Need Help My Next Step!

If B2 is blank then Blank
If B2 is C2 then Correct
If B2 is not blank and not C2 then Incorrect

I Need E2 to be 0 and if someone answers a question i need it to go to 1

if d2 is correct or incorrect e2=1
but if it is blank to be 0

btw who is tim?

ty again you help loads

put in E1

=IF(D2="",0,1)

Regards

**Snooza35** · 10-12-2006, 05:37 AM

Thanks Again,

Btw is there any how i can lock the cells but still be able to type in a few certains ones?

Im Still New To Excel So Help Will Be Much Apreciated.

Snooza

**starguy** · 10-13-2006, 02:11 AM

Originally Posted by Snooza35

Thanks Again,

Btw is there any how i can lock the cells but still be able to type in a few certains ones?

Im Still New To Excel So Help Will Be Much Apreciated.

Snooza

select all those cells which you want to allow for data entry. (you need to select one by one if they are not in a range)
right click on that cell > click Format Cell...
under Protection tab uncheck Lock option.
(repeat this process for all cells you want to allow data entry)

now protect your sheet.
go to Tools menu > Protection > Protect Sheet > (enter passward if you want) press Ok

now you can enter data only in those cells which you have unlocked (unchecked the Lock option).

to enter data in all cells you need to unprotect sheet.
Tools > Protection > Unprotect sheet.

Regards.