View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default EXACT doesn't fill in the result

There are 2 likely reason why this is happening.

First, check to make sure that the Display Formula option is turned off.
1. Goto TOOLS Menu
2. Select OPTIONS
3. On the VIEW Tab, uncheck "Formulas"
4. Click OK

If that's not it, make sure the cell containing the formula is not formatted
as text.
1. Select the cell your formula is in
2. Goto the FORMAT Menu
3. Select CELLS
4. On the NUMBER Tab, select "General"
5. Click OK
6. Re-enter your formula

HTH,
Elkar


"DBinSD" wrote:

I know this is probably the simplist thing, but I cannot figure it out. I
put in the EXACT function via the tool, enter my values for cell1 and cell2.
In the function box it shows TRUE or FALSE, but in the cells themselves only
the formula shows (=EXACT(A4,C4) - not TRUE or FALSE. I tried to do the copy
and paste value to show the result but that also doesn't work. It must be
something simple, but I'm just not seeing it.
Thank you - dbentley