If (value is an integer, return value, otherwise 1)

October 21, 2013 at 01:27:43
Specs: Windows 7
Some entries in items column include decimal points (i.e. sold by weight) I need to sum the column, BUT all values NOT an integer need to be counted as "1".

See More: If (value is an integer, return value, otherwise 1)

Report •


#1
October 21, 2013 at 06:33:17
An integer is defined as a number with no fractional part,
so if a cell has a value of 5.2, or 3.55
you still want it to be counted as only 1 ?

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question