if text in range then count as 0 to finsh calculation

[ianmcw]

Hi i am trying to add c23+c23 then total in D23 but the issue with my sheet is that everything in C is sq yds and in D is sq ft, so i need to convert sq yd to sq ft to get an accurate count

so i used this formula =(C23*9)+D23 this works fine until there is text in any of the cells
so then i tried =CONVERT(CONVERT(C12,"yd","ft"),"yd","ft")+D12
and this =IF(ISTEXT(C18:D18),"0","")*(C18*9)+D18
But still cant get the formula to count properly because of the text alwatys get #value error

any help on this would be great dont know if it would be better with vba or not

[sktneer]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ianmcw]

test-yds-ft.xlsx

i have attached test file with data which is correct and wrong thanks for looking at this for me

[sktneer]

Try this.....

In E4

Please Login or Register  to view this content.

and copy down.

Does this help?

[ianmcw]

@ Sktneer this works great i really appreciate your help thank you