LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 280
Default If, then...

or SUM(E29,G28,-F29), if you prefer.

--
Bob Kilmer


"Tom Ogilvy" wrote in message
...
sum is redundant, just do

=E29+G28-F29

--
Regards,
Tom Ogilvy


Jonas Weebler wrote in message
om...
I have a simple formula in a cell: =SUM(E29+G28-F29)

Is there a way to change the color of the cell when the value in the
cell goes above or below zero with an "If / Then" statement? Thank
you in advance.





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"