- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Results of formula vs real numbers

Subject: | Results of formula vs real numbers |

Posted by: | J.W. Aldridge (jeremy.w.aldrid…@gmail.com) |

Date: | Thu, 24 Jul 2008 |

HI.

How do you change a formula to read the value as a result of a formula

and not necessarily as a real number?

Example:

In G6, i have the following formula that gives me the hour of a time

in F6

=IF(F6>0,MOD(F6-"1:00",1),"")

F6 contains 00:30:08, The result is 23

In another cell, I am using this formula, but it doesnt recognize the

23.

=SUMPRODUCT(--(B6:B58331="james"),--(G6:G58331="23"))

The 23 is actually the HOUR of time so it isn't a whole number or real

number persay. It is a rounded time to the hour.

- Re: Results of formula vs real numbers posted by Pete_UK on Thu, 24 Jul 2008
- Re: Results of formula vs real numbers posted by Peo Sjoblom on Thu, 24 Jul 2008