Help with formula please

[blackie42]

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

[mana]

=IF(B2="A",(MID(C2,4,1)),IF(B2="B",MID(C2,5,1),""))

[blackie42]

This just returns an error (and I have tried this already)

Thanks for trying

regards
Jon

[YasserKhalil]

May be you have to replace , with ; (It can be changed from regional settings)

[Paul_Hossler]

Maybe




=IF(C2<>"",IF(B2="A",(MID(C2,4,1)),IF(B2="B",(MID(C2,5,1)))),"")

[Aussiebear]

Like your concept Paul

[Paul_Hossler]

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]

Works fine Paul

Many thanks

Jon