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

Who says A3 is a formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike" wrote in message ...
| 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.