Asta

Posts: n/a

Wrong syntax

I have created this: =IF(AND(C4300,C4<400),(C4-43)*0.36,"")
but i'd like to add more in the greater,Smaller than category and on each
add different subtractions and multiplication. How would i do such a thing?

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
wrong syntax	Asta	Excel Discussion (Misc queries)	1	February 12th 05 09:39 AM
I get wrong dates when i paste from a different sheet into a new s	mmollat	Excel Discussion (Misc queries)	2	January 6th 05 07:35 PM
Vlookup Syntax Error	YV	New Users to Excel	9	December 23rd 04 05:28 PM
when writing an IF statement what is the syntax for "Not Equal to.	NEEDTOKNOW	Excel Discussion (Misc queries)	1	December 10th 04 04:45 PM
Previous Post - Correct Syntax Query	Clarence Crow	Excel Worksheet Functions	0	December 7th 04 05:35 AM

All times are GMT +1. The time now is 11:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us