remove #n/a from my cell

[ravihotwok]

i have the following formula:

=REPT(Estimator!D8,(Estimator!E8="Yes"))

when it is not in use or false it displays #N/A

Can anyone tell me how I can just have it blank when not true?

Thanks

[royUK]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions

[arthurbr]

try =if (isna(REPT(Estimator!D8,(Estimator!E8="Yes")),"",REPT(Estimator!D8,(Estimator!E8="Yes"))

[royUK]

See the alternatives here:

http://www.excel-it.com/excel_condit...formatting.htm

[ravihotwok]

try =if (isna(REPT(Estimator!D8,(Estimator!E8="Yes")),"",REPT(Estimator!D8,(Estimator!E8="Yes"))

Thanks for that but it didnt cure it, ended up with a lot of text in the cell??

Roy, sorry about posting it in programming, I thought thats what it was, now I know it is a function, im still getting used to the terminology ;-)

[martindwilson]

missing parenthesis
try

Please Login or Register  to view this content.