View Single Post
  #1   Report Post  
Anthony
 
Posts: n/a
Default Another Formula question - please

me again !!

I'll get the hang of excel -on day!

anyway heres the question

if the value of 'Invoice Data'!R2 = £0.00 I want n/a shown in cell I26, but
if there is a value other than £0.00 in 'Invoice Data'!R2 , then show that in
cell I26.

Hope that's clear and thanks again