Help with Xcel IF formula

**stephsa** · 09-11-2014, 11:09 AM

Hello

Hoping someone can help.

I have added a drop list in xcel of about 10 options, when one of the options is selected I want the price to show in another column.

I have tried this =IF(D44="CTI63","711.40") but it does not work

Please help

**dhanabharathi2** · 09-11-2014, 11:13 AM

In "If"condition, we must give true or false value. You can try using this =IF(D1="CT163","711.30",0) which will give you 0 value if value is false.

**stephsa** · 09-11-2014, 11:17 AM

I have just tried this and it only shows false not a value?

**Vikas_Gautam** · 09-11-2014, 12:50 PM

Hi Stephsa..
Check whether if there are leading and following space after/before the text your are comparing in the IF statement...
You have also mentioned that you wanna result another column...
I guess for that matter, you should consider vlookup or Lookup function as an option....