Hey all

I currently have =('Sheet1"!A1+'Sheet1"!A2")*N3/(N38+N40)

Suppose: Sheet1, A1 value = 38 and Sheet1, A2 value = 40
How do I make it show =(38+40)*N3/(N38+N40) in the formula bar?

I only need the cell referencing from a different sheet to change to integers ... help!

Thanks
Jason