SOLVED

Excel Formula

Copper Contributor

I want the results from two different formula to be answered in one cell divided by a space / and another space. The following formula works as far as results go. But I need to be able to divide the results.

 

='IN-DOT Gyro Data'!AS5&'IN-DOT Gyro Data'!AS5-'IN-DOT Gyro Data'!AY5

 

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@Troy_Stouffer 

='IN-DOT Gyro Data'!AS5 & " / " & 'IN-DOT Gyro Data'!AS5-'IN-DOT Gyro Data'!AY5

@Hans Vogelaar

Thank You Very Much! Works Great! 

1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
Solution

@Troy_Stouffer 

='IN-DOT Gyro Data'!AS5 & " / " & 'IN-DOT Gyro Data'!AS5-'IN-DOT Gyro Data'!AY5

View solution in original post