Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with if/and formula
I need help with a simple task, but I'm stumped! The formula below works,
except when the value in colmn H is 0. 1. or 2. Unfortunately, those values can be in that column and I can't figure out how to write the formula the way it really needs to be, which is basically that I want it to return the value "2500" only if the the value in column H is BETWEEN 3 and 25. Please help!!! =IF(AND(H3=3,H3<=25),100*H3,2500) Thanks... |