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
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
Last edited by ravihotwok; 01-13-2009 at 06:27 AM.
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
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
try =if (isna(REPT(Estimator!D8,(Estimator!E8="Yes")),"",REPT(Estimator!D8,(Estimator!E8="Yes"))
See the alternatives here:
http://www.excel-it.com/excel_condit...formatting.htm
missing parenthesis
try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks