I need this to work in one cell, but it returns a 0.00 every time

[cowgirl]

THIS IS WHAT I THINK IT SHOULD LOOK LIKE BUT, IT ALWAYS RETURNS 0.00
=IF(AND(H29>=95001<=100000,H29*G32),"$0.00"). (H29) WOULD BE 95001.00 X (G32) WOULD BE 2.0%

Thank you

 

[Hui]

Cowgirl

Your formula should be:
=IF(AND(H29>=95001, H29<=100000),H29*G32, $0.00)

 

[cowgirl]

hi Hui,
Thank you it worked.
Darla