Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrfrenchy mrfrenchy is offline
external usenet poster
 
Posts: 4
Default IF Function

Hi, another request. Try to use the IF function for homework.

If a cell total is greater than 12 each point gets a bonus point. If the
total is less than 12 they get penalized 2 points each. I started with what
I have below but now it's all just a blur. :)

=IF(G412),((12-G4)*1),((12-G4)*-2))

Thanks for any help out there!!