View Full Version : [SOLVED:] Help with formula please
blackie42
10-07-2016, 01:54 AM
Hi,
getting a 'FALSE' in cell with following formula
=IF(B2="A",(MID(C2,4,1)),IF(B2="B",(MID(C2,5,1)))) when B2/C2 are empty.
Can't figure out how to make it blank - any ideas how to fix please
thanks
Jon
=IF(B2="A",(MID(C2,4,1)),IF(B2="B",MID(C2,5,1),""))
blackie42
10-07-2016, 03:51 AM
This just returns an error (and I have tried this already)
Thanks for trying
regards
Jon
YasserKhalil
10-07-2016, 05:42 AM
May be you have to replace , with ; (It can be changed from regional settings)
Paul_Hossler
10-07-2016, 05:31 PM
Maybe
=IF(C2<>"",IF(B2="A",(MID(C2,4,1)),IF(B2="B",(MID(C2,5,1)))),"")
Aussiebear
10-07-2016, 05:37 PM
Like your concept Paul
Paul_Hossler
10-07-2016, 06:40 PM
Like your concept Paul
thanks, but the answer was really in the OP's #1
when B2/C2 are empty.
so I just checked for when C2 is not empty
blackie42
10-08-2016, 08:44 AM
Works fine Paul
Many thanks
Jon
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.