formula for the total columns

[jv]

Happy New Year to All!!!,


I want to make a formula for the following column.

A B C D E F
1 Date Ring H1 Consn. Ring H15 Consn. Total
2 1-Jan-04 29,474.87 21.13 30,811.28 31.81 52.94
3 2-Jan-04 29,495.99 21.12 30,842.32 31.04 52.16


1 - In column C3 - If the entry from B3 is less than B2,
then show 'Error' and if B3 is blank, show '-', otherwise
show the result ( B3-B2 ).

2 - In column F3 ( C3+E3 ) - if the result in F3 is
greater than F2, show the result in 'red color',if it is
less show the result in 'blue color'.

I want to copy these formula all the way down up to the
end of the month ( Jan 01-31 ). Is it possible.

Thanks and regards.

jv

 

[Bob Phillips]

JV

In C3,
=IF(B3<B2,"Error",IF(B3="","-",B3-B2))
and copy down

In F3, lookup conditional formating for what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[jv]

Bob,

Gee, It works! I have the idea but i dont know how to
organize a formula. My head is already aching trying to
figure out this problem.

Thanks for the tips, it helps a lot.

jv