IF statement help needed!

[iouu2]

hello i am a little about excel IF statements.
basically what i want to do is make sure the intended users of a form, fill it out in WHOLE (completely).

the IF statement/rule is that both the project # (B21) and unit price (U21) need to be populated for the total price (V21) to show value.

keep in mind i have a IF statement in V21 (total price).

CLicking on the link below is a example of what I am referring to. I need to make sure the code applies to each line item!

http://img821.imageshack.us/f/examplelj.png/

Thanks for the help/advice!

 

[iouu2]

Here's a link. I was unsure how to share a screen shot with your windows live account.

http://i53.tinypic.com/14j2tec.jpg

 

[iouu2]

Ok, it seems that I have even confused myself. Thank you for the suggestions regarding that aspect of the code.

The ideal goal was so that users must select every option/fill in every detail before proceeding.

Ideally, from the very start. To complete the form, the user must start from the very start selecting YES or NO.

In excel, is there a way where I could potentially black out/lock the entire page QUESTION by QUESTION. For instance, if you take a look at the screen shot, I wanted to generate a IF statements a long the way (probably working backwards) where the user has to select YES or NO then can proceed to #2 then #3 etc etc etc.

http://i56.tinypic.com/296lnk0.jpg

This file is a locked sheet for users so they can't format any of the cells other than selecting from the drop down and clicking on check marks.

The goal I intended was for the user to go step by step completing the form in its entirety.

I want to thank all of you for your help.

 

[Smitty]

Here's a link. I was unsure how to share a screen shot with your windows live account.

Actually, you don't do anything with my SkyDrive account, that's just where I put the board's HTML maker so people could access it.

The HTML Maker itself is an Excel-Add in file that you load on your PC. It will allow you to select an area of your screen and convert it to HTML, which you then post here. When you submit your post that code is rendered as a screen shot.

In excel, is there a way where I could potentially black out/lock the entire page QUESTION by QUESTION. For instance, if you take a look at the screen shot, I wanted to generate a IF statements a long the way (probably working backwards) where the user has to select YES or NO then can proceed to #2 then #3 etc etc etc.

It can be done, but the only way to do that is with VBA.