I am Getting #N/A
I am trying to subtract I6 from 2 and put it in G12 but I want it to = zero
until I tell it to subtract, right now if it is left blank it will give me #N/A below is the formula that I am using. ='Client Info'!I6-2 Here is how I am getting I6 =INDEX(B316:B373, MATCH(B9,C316:C373,0)) Any help would be appericated |
All times are GMT +1. The time now is 07:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com