That will work if I use a new column. Is there anyway to do it in the
existing column
so something like
C100=IF(C100="","",IF(AND(OR(A100={369,391}),B100= "Gas"),54,C100))



Max wrote:
Maybe you mean something like this in say, D100:
=IF(C100="","",IF(AND(OR(A100={369,391}),B100="Gas "),54,C100))

Provided C100 isn't empty (this is just a first check done on C100), D100
will then return the value in C100 as the value_if_False (instead of the
previous value of 18)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rub" wrote in message
ups.com...
I have a different twist on the same question. For some cells I need
to leave the current value in the cell alone if the IF premise if
false. So in other words instead of the value being 18, I would like
to not change the value of the cell. Any ideas?