Posted to microsoft.public.excel.worksheet.functions

C Kreig

external usenet poster

Posts: 21

Formula If statement.

I would like to get a formula
=IF((B1=X),(Value=0),IF(B2=X,(Value=5),IF(B3=X,(Va lue=10)))
I keep getting an error telling me that I am missing a parenthesis.

I would also like to add in the fomula that if it is blank do not calculate
the value.

Thank you in advance for your help.

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 statement in formula	Derrick	Excel Discussion (Misc queries)	7	July 8th 09 06:16 PM
IF THEN statement - Formula	walkerT	Excel Discussion (Misc queries)	3	March 13th 07 07:20 PM
IF statement formula	JaB	Excel Worksheet Functions	4	September 15th 06 04:12 PM
Can I use IF statement with a formula?	Michael NYC	Excel Worksheet Functions	1	October 1st 05 04:45 AM
If statement formula	lintan	Excel Worksheet Functions	6	November 22nd 04 10:29 PM

All times are GMT +1. The time now is 10:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us