Formulas

folds · Apr 16th, 2002, 07:07 PM

Write an IF function for cell H5 that assigns the text "Eligible" if the value in cell H12 is three times greater than the value in cell H13; otherwise the IF function assigns the text "Not Eligible".

Jay Petrulis · Apr 16th, 2002, 07:10 PM

Hi,

Your teacher should ban the use of the Newsgroups to do these.

This exact question was just asked. See:

http://www.mrexcel.com/board/viewtop...5392&forum=2&4

Bye,
Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 07:07 PM	#1
folds New Member Join Date: Apr 2002 Location: Juanita Pless Posts: 1	Write an IF function for cell H5 that assigns the text "Eligible" if the value in cell H12 is three times greater than the value in cell H13; otherwise the IF function assigns the text "Not Eligible".

Apr 16th, 2002, 07:10 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Your teacher should ban the use of the Newsgroups to do these. This exact question was just asked. See: http://www.mrexcel.com/board/viewtop...5392&forum=2&4 Bye, Jay