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
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
I see you are using 2007.

Try...

IFERROR(value,value_if_error)

Look in Excel help for more info.
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top