If/Then Statements

  • Thread starter Thread starter MrExcelWannaB
  • Start date Start date
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!
 
try

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

regards from Brazil
Marcelo


"MrExcelWannaB" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting IF/OR Statement 14
Rounding up to a multiple of 12 1
Trying to avoid nested IFs 8
LIST OF PERSON'S NAMES 1
repeating values 1
Conflicting results in formulas? 4
Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1

Back
Top