Anybody good at excel IF formula

  hastelloy 12:18 14 Mar 2018
Locked
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.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei Mate 20 Pro review: In-depth hands-on

See concept art from groundbreaking video games including The Last of Us, Journey and No Man's Sky

iPhone XR release date, price & specs

Les meilleurs VPN pour Kodi (2018)