View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Converting formula from Lotus123 to Excel

Hi Lisa,

Am Fri, 30 May 2014 19:45:33 +0100 schrieb Lisa V:

@IF(A87=1000#AND#($D$2-IU87)0#AND#IV87="",(@IF((D87$D$3),(D87-$D$3),"")),D87)


try:

=IF(AND(A87=1000,$D$2-IU870,V87="",D87$D$3),D87-$D$3,"")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional