making a box create a code

  • Thread starter Thread starter Rick Wolfe
  • Start date Start date
R

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?
 
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
 
Back
Top