Hi Barbi,

Try:
=IF(M81<100,4200710,IF(M81<750,6000100,1201060))&I F(I81="TONER",6001000,4200710)

--
Cheers
macropod
[MVP - Microsoft Word]


"barbi b" <barbi wrote in message ...
please see following formula:
=IF(M81100<750,"6000100","4200710")&IF(M81=750," 1201060","4200710")&IF(I81="TONER","6001000","4200 710")
I need to return numbers in a cell if the $ is less than 100, return
4200710, greater than 100 but less than 750, return 6000100, and if 750,
return 1201060 and then if "I" column has the text "TONER" return 4700710.
this the result of my formula, i know i am close and i just missing the
"key" elements to get this to work..excel 2007
420071012010604200710