View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Colin is offline
external usenet poster
 
Posts: 86
Default IF Function - Specific currency format

Hello,

How do I write a function that only returns a value if the cell (A1) is of
the currency Euro. I assume the If function would be used. Here is what i
want it do.

=IF(A1 is currency EURO, *0.61,"")

I'm not sure if the TYPE or CELL function is used with it or another function.

Many thanks,
--
Thank you,

Colin.