View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Difficult function

no different than the other but just to note A3 will never be blank because
it's a formula, it may be zero.

=IF(A1*A2=0,"",IF(A1*A2=A3,"Good","Try Again"))

"Toppers" wrote:

in C3:

=IF(A3="","",IF(A1*A2=A3,"Good","TryAgain"))

Will this do?

"Teacher in Revetal" wrote:

Can anyone help me? I need a function that provides the following:
If a1*a2=a3, then show Good, else show Try again. This function is written
in c3, and I can make it work. But if a3 is a blanc, i want to show c3 as a
blank without ruining the function in c3. Is this possible? My students are
making a math-game.