Hi
does the formula
=($E$5+$E$6)($E$4*2)
do what you want?
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Mr Anonymouse" wrote in message
...
I'm getting stuck on something really basic. I want to compare the sum of
two cells with the value of one cell multiplied and, if greater, turn the
cell red.
I'm entering the formula and it's appearing as follows:
=IF+$E$5:$E$6$E$4*2
It won't work. Anyone tell me what I'm doing wrong?
Thanks