try

=if(L56,"Complete",(6-L5))

regards from Brazil
Marcelo


"MrExcelWannaB" escreveu:


Hello all!

I need help with an If/Then statements.

I want the function to do the following, if the number in column A is
than 6 it should comeback as complete. If the numberin column A is <
than 6 I want the function to subtract 6 from that number and come back
with a total.

Here's what I have written:

=if(L56,Complete,(6-L5))

When I hit enter I get #NAME?

What am I doing wrong?

Any help you could provide would be greatly appreciated!

Thanks!


--
MrExcelWannaB
------------------------------------------------------------------------
MrExcelWannaB's Profile: http://www.excelforum.com/member.php...o&userid=34842
View this thread: http://www.excelforum.com/showthread...hreadid=545889