Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default IF function

=IF((S3/5)=F4,"OK","NOT OK")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Bob J"
wrote in message
how would i write an if function for cell P8 that assigns the text "OK" if
the value in cell S3 is five times greater than the value in cell F4;
otherwise, have the if function assign the text "NOT OK" to cell P8