logical formula returns #value

[howard]

I have the following if formula below which returns #value

 =IF(B3="","",B3*100/Vat_15Percent/100),IF(C3<>"",C3*100/Vat_15Percent/100)

Cell B3 or Cell C3 will either contain a value

It would be appreciated if someone could kindly assist me

 

[arunsjain]

Try this

=IFS(B3="","",B3<>"",B3*100/Vat_15Percent/100,C3="","",C3<>"",C3*100/Vat_15Percent/100)

 

[howard]

Thanks Formula works perfectly