making a box create a code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Wolfe - 28 Jan 2008 22:20 GMT

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?

Signature

Rick Wolfe
Malaspina Coach Lines

Reply to this Message

Bernard Liengme - 28 Jan 2008 22:27 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

Reply to this Message