EXCEL Formula-Not Working

zteam777

New Member
Joined
Nov 15, 2009
Messages
11
I had a few responses to an earlier thread I wrote but the formulas given were not working. Obviously I am doing something wrong, please help.

Earlier I wrote:
This one is simple, just need help with it.

I have 2 worksheets created in the same file. One labeled Work Order and one labeled Invoice.

They are exactly alike accept for the headings on each worksheet and a few slight differences.

I simply want whats typed on the some of the fields on the work order to be copied to the invoice to avoid typing the info twice.

Yes, I did go to the invoice field and type = then to the work order same field and press enter, that works fine, however on the invoice it leaves a 0 until something is entered on the work order.

The problem with that is some of the fields may not need info typed in on the work order thus leaving all of these 0's on the invoice.

I need the formula without it showing the 0's.

Please keep in mind that the cells are labelled the same on each.

AW4 on each sheet.

Please help.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
I can't imagine no-one gave you the correct formula for that. I use it thousands of times:

=if('Work Order'!A5="","",'Work Order'!A5="")

this makes it display "" (which is empty cell) if the cell on the Work Order sheet is blank. Else it puts in the value.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,747
Messages
5,638,118
Members
417,010
Latest member
jnuss03

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top