Menu

if statement problem

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

If they are numbers, take out the " " and try again

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
hi,
I need an if formula like
b1=if(a1="14,50","10,50",if(a1="14,00","10,00",if( a1="13,50","18","0")))
but this formula does not work.
can anybody help me?

Reply With Quote

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 Problem	Bryan	Excel Worksheet Functions	5	July 29th 05 04:10 PM
Problem with nested IF_OR statement	DOOGIE	Excel Worksheet Functions	7	June 24th 05 03:27 AM
Fundamental problem with IF statement	David F	Excel Worksheet Functions	3	May 17th 05 03:42 PM
Fundamental problem with IF statement	David F	Excel Worksheet Functions	4	May 12th 05 09:34 PM
IF statement problem	simon	Excel Worksheet Functions	1	December 30th 04 10:59 AM

All times are GMT +1. The time now is 08:54 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement