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

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

Converting formula from Lotus123 to Excel
 

"Claus Busch" wrote:
LL in message ...
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,"")

In you zeal to try to simplify, I believe you introduced a difference.

The following is a direct translation. It returns D87 when the first
condition is false.

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