Ironworks Gaming Forum - View Single Post

Night Stalker · 04-21-2003, 10:16 PM

the function you want to put in the cell is:

=Iff(A1 > 150, .9 * A1, "N/A")

This assumes that cell A1 holds the value for total charge. Replace with the actual cell containing the value.

For more info on excel functions click the button that kinda looks like f*()...

04-21-2003, 10:16 PM	#2
Night Stalker Lord Ao Join Date: June 24, 2002 Location: Nevernever Land Age: 51 Posts: 2,002	the function you want to put in the cell is: =Iff(A1 > 150, .9 * A1, "N/A") This assumes that cell A1 holds the value for total charge. Replace with the actual cell containing the value. For more info on excel functions click the button that kinda looks like f*()... __________________ [url]\"http://www.duryea.org/pinky/gurkin.wav\" target=\"_blank\">AYPWIP?</a> .... <img border=\"0\" alt=\"[1ponder]\" title=\"\" src=\"graemlins/1ponder.gif\" /> <br />\"I think so Brain, but isn\'t a cucumber that small called a gherkin?\"<br /><br />Shut UP! Pinky!