I am probable doing someting stupid but I cannot get this to work:
This formula works fine:
=IF(EXACT(E2,"Dwarf"),INT((B10/3)),)+IF(EXACT(R1,"Barbarian"),INT((B10/3)),)+P10+AN1+'Level 4'!D717
This formula pulls the value in cell D717 on Sheet 'Level 4'! and adds it to the string and displays...