IF formula with Currency sign

Cell A1 has values in Currency sign - $100
Cell A2 has values in Currency sign - Euro200

I want to make an IF formula in cell B1 - If(a1="$",123,321)

Note: Basically if a cell has dollar sign then separate calculation and if cell having euro sign then separate calculation

Kindly provide formula

could u please upload a sample file with desired result.

Maybe this?

Formula:

Please Login or Register  to view this content.

v	A	B
1	$100	100
2	Euro200	200
3	456	456
4	201545	201545
5	Euro1551	1551

$100

Is that text or a number?
If it's a number then the $ sign will not be readable by your IF as it part of the FORMAT not part of the value.

Try

IF(LEFT(A1,1)="$",123,321)
IF(LEFT(A1,4)+"Euro",123,321)

otherwise the cells are numbers and you'll need to determine the FORMAT of the cells probably using
=CELL("format",A1)

Originally Posted by dino4u86

Numbers are with currency symbols. Hence the symbols will not display in a cell and the left formula cannot be used. For eg in $100 Currency Symbol $ is used and Euro 200 currency symbol E is used

There are no currency symbols in you attached sheet. The cells are simply formatted as currency. There are no formulas that can deal with formats in the way you want it. You should look for VBA solution for your problem.