Nested HLOOKUP Function

[mgoldman0998]

Ok so basically I need to nest an HLOOKUP function inside of an IF function. If the HLOOKUP value is positive, I want the numeric value. If it is negative, I want it to just have a hyphen. Here is the formula I produced, which will only give me numeric values, the hyphen will not come up for negatives.

=IF(D$25+D$23*HLOOKUP($C28,$O$9:$R$12,3,0)>0,D$25+D$23*HLOOKUP($C28,$O$9:$R$12,3,0),"-")

[FDibbins]

Hi, welcome to the forum

hard to say without seeing any test data, but it looks like it should work. Perhaps...

=IF(D$25+D$23*HLOOKUP($C28,$O$9:$R$12,3,0)>=0,D$25+D$23*HLOOKUP($C28,$O$9:$R$12,3,0),"-")

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.