View Single Post
  #1   Report Post  
Lisa V Lisa V is offline
Junior Member
 
Posts: 1
Red face Converting formula from Lotus123 to Excel

I need some help. I am trying to convert a Lotus formula into Excel, but Excel will not convert it. The Lotus Formula is:

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

Unfortunately I do not know enough about Lotus formulas to understand this one. I would be greatly appreciative if anyone can help me figure out the Excel conversion.

Thanks!

Lisa V