What does the ! stand for in Formula

L

Luis

In the formula =If (02="carports,"'input data' ! $B*X2*1000,"ERROR" What
does the ! stand for in Formula
 
A

AltaEgo

It is a separator between the sheet name and the cell address... and I
suspect your formula should look like this:

=IF(O2="carports",'input data'!$BX2*1000,"ERROR")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag formula across making chgs on the way 5
If formula and Data Validation parallely 1
drag formula down making chgs on the way (Q2) 5
Excel Need Countifs Formula Help 0
Formulas 1
Excel Help to copy information from one row at a time to another sheet 1
Formula for increasing a result to the next highest 1000 2
Excel formula ^ 1

Top