Value returning 0

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi Guys

I have a formula in a spreadsheet
=Original!C33

there is nothing in Original!C33 but a 0 is being returned. How do I
get rid of these anomolies?

Thanks

Brian
 
Hi Brian,

=IF(Original!C33="","",Original!C33)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Guys
|
| I have a formula in a spreadsheet
| =Original!C33
|
| there is nothing in Original!C33 but a 0 is being returned. How do I
| get rid of these anomolies?
|
| Thanks
|
| Brian
 
Hi Brian,

=IF(Original!C33="","",Original!C33)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi Guys
|
| I have a formula in a spreadsheet
| =Original!C33
|
| there is nothing in Original!C33 but a 0 is being returned. How do I
| get rid of these anomolies?
|
| Thanks
|
| Brian
Click to expand...

Thanks

worked a treat
 
Back
Top