Help with Formula Please (Display text if no value exists)

Kynan

New Member
Joined
Apr 7, 2011
Messages
12
I'm trying to calculate a number using multiple cells and the vloopup function (as shown in formula below). If no value exists it's returning "#VALUE!" in the cell, if a value exists then it works fine and gives me the correct number, however whenever no value exists I want it to display "N/A" or "-".

The current formula...
=($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7)

I have tried;
IF(ISNA(($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7)),"-",($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7))
But for some reason can't get it to work...

Any suggestions?

Thanks
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
I see you are using 2007.

Try...

IFERROR(value,value_if_error)

Look in Excel help for more info.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,114
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top