multiple formulas

[Just4me]

Hi, I am doing a spreadsheet and most of the time I can easily find the answer to my question in one of your threads. but not this time.. here is my formula. =IFERROR(ABS(E3-D3)/D3,"") I only want an answer if there are values/numbers in cell E3 and D3. any suggestions? again I want to say thank God for these threads.

 

[JonXL]

hi, i am doing a spreadsheet and most of the time i can easily find the answer to my question in one of your threads. But not this time.. Here is my formula. =iferror(abs(e3-d3)/d3,"") i only want an answer if there are values/numbers in cell e3 and d3. Any suggestions? Again i want to say thank god for these threads.

Try...

=IF(AND(E3<>"",D3<>""),ABS(E3-D3)/D3,"")

 

[Just4me]

Try...

=IF(AND(E3<>"",D3<>""),ABS(E3-D3)/D3,"")

Awesome.. thank you so much.