Thread: Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ?

I don't know if this helps at all,
but to format a cell into european curency select the cell, go to
format cells and select the numbers tab
select curency, then hit the symbol menu, and select the curency you
want,
hopefully then your formula will be recognized


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519180

Reply With QuoteReply With Quote