If/Then Statements

M

MrExcelWannaB

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(L5>6,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!
 
M

Marcelo

try

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

regards from Brazil
Marcelo


"MrExcelWannaB" escreveu:
 
Top