Anybody good at excel IF formula

  hastelloy 12:18 14 Mar 2018
Answered

I have a spreadsheet and I want B3 to be blank if B2 is blank. Somehow I just can't get my head around it (must be my age!). Any suggestion gratefully received.

  wiganken2 13:01 14 Mar 2018
Answer

Is the following any help? click here

  hastelloy 13:42 14 Mar 2018

Many thanks wiganken2. Even using this it took me a while to get it right but I did.

What is Markdown?

Markdown lets you add more formatting to your post. Simply type in your post and it will display as written.

If you wish to add bold or italic characters, add a hyperlink to another website, a heading or a horizontal line, simply use the relevent icons above the text input field.

A preview of your post will appear in the grey box below. If you make a change and you're not happy, simply press the back arrow icon to undo.

Post a Reply

4500

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Iglooghost's hyper new music video gives a mutant take on Monument Valley

The best Amazon Prime Day Apple deals 2018

Comment ajouter de la musique à une présentation Google Slides ?