making a box create a code

[Rick Wolfe]

I am having a hard time understanding the 'if' and 'and'; 'or'.
I am trying to have a box on a spreadsheet that when it is'checked' creates
a code on another page. This code would generate a dollar value.
How do I go about doing this?

 

[Bernard Liengme]

Try this anywhere on Sheet2 with X typed in A1 of Sheet1 and then with Z
=IF(Sheet1!A1="X",25,IF(Sheet1!="Z",45,0))
then tell us what is wrong
best wishes