# Need help with a function formula...

#### AliGW

##### Active Member
This maybe:

=IF(\$L15="","-",IF(VLOOKUP(\$L15,Table1,2,FALSE)>2,"-",O15*P15))

#### Kristen_cancerkiller

##### Member
That did it Thank you!

#### Kristen_cancerkiller

##### Member
So following that method, can you tell me why this isn't working?

=IF(\$T3="","",IF('Travel Expense Voucher'!\$F\$5=2,IF(T3<>12,'Tcodes and Ecodes'!\$G\$6,'Tcodes and Ecodes'!\$G\$7),IF(T3<>12,IF(M3="In-State",'Tcodes and Ecodes'!\$G\$12,'Tcodes and Ecodes'!\$G\$13),IF(M3="In-State",'Tcodes and Ecodes'!\$G\$11,'Tcodes and Ecodes'!\$G\$14))))

I'm not getting any type of error, but it is not leaving the field blank if T3 is blank?

#### NARAYANK991

##### Excel Ninja
Hi ,

If visually T3 is blank , but you are getting a value in U3 where this formula is entered , then it is likely that T3 contains a space character or 0 from its formula.

Narayan

#### Kristen_cancerkiller

##### Member
I don't see that it does.

#### Attachments

• 95.3 KB Views: 1

#### NARAYANK991

##### Excel Ninja
Hi ,

Go to any cell which is visually blank in column T , say T10.

With the cursor in that cell , press F2 and F9 ; this is to evaluate the formula in that cell.

You should see a 0.

Replace the formula in column T , which is at present :

='Travel Expense Voucher'!R15

with this :

=IF('Travel Expense Voucher'!R15 = 0, "", 'Travel Expense Voucher'!R15)

or this :

=IF('Travel Expense Voucher'!R15 = "", "", 'Travel Expense Voucher'!R15)

Narayan

#### Kristen_cancerkiller

##### Member
WOW!! That shouldn't have been so hard for me. But it sure was! I'm sorry... but thank you!!