Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Currently I have an "if" formula that looks a value on another sheet which
looks like this =IF('Start Page'!$E$19<100000,G15,0). My problem is that when 100,000 is put in it does not caluculate correctly because it is not < but = to. Answer =IF('Start Page'!$E$19<=100,000,G15,0) The question above was answered, however I failed to look at other factors. I also need the formula to read but not less than 10,001 |