Hey everybody,

I need help with a formula. I'm trying to write a formula that has 3 functions. Here is my example, I got Cell B2 that is based off the value of cell A2, I need a formula that if A2 contains any text then cell B2 will return the text "N/A", and if cell A2 contains any number then cell B2 will return a formula, however (here is my issue) if cell A2 is blank then i would like cell B2 to also remain blank. This is the formula i came up with that returns:
=IF(ISNUMBER(A2),(100-(A2*100))/100, if(ISTEXT(A2),"N/A"), if(ISBLANK(A2),""))

Any help is most appreciated

Thanks.