Building a Conditional Formula with the IF Function


Posted by Bill on October 18, 2000 5:37 PM

How do I get a message to display in a cell using the IF function in a conditional formula? Ex.: If student receives an "A", I want "Congrats" to display in an ajaucnt cell.



Posted by Celia on October 18, 2000 7:02 PM


Bill
Put in B1 :-

=IF(A1="A","Congrats","")

Celia