ex. Can you use the IF formula in each cell within a column and g.

[cinque]

--
oes716

 

[Frank Kabel]

Hi
post your question as body of your message

 

[cinque]

ex. I have a column "c" that has IF functions included in each cell but I
want a sum(totals) of each of those cells but it won't add all the cells for
me. It just gives me a total of $0.00. Is it not adding the cells together
because of the IF functions I have in each cell? I audited the the column &
cells for errors but their weren't any. Please help.

 

[Myrna Larson]

Please post the exact formula you are using for your IF function.

 

[NovicExcel]

Here is a scenerio

Food Yes/No
Apple No Yes Revise Your Diet
Banana Yes No
Pears Yes


Revise Your Diet




"Revise Your Diet " is an Error Message &
My question is how to Make this flash.. blink etc ??? bottomline is how or
is it possible to flash back such error with some effect that alerts
instantly . Like in online EXAM or poll or survey etc. How to do so in EXCEL.

 

[Chip Pearson]

Excel does not support flashing text.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...

 

[NovicExcel]

Here is a scenerio

Food Yes/No
Apple No Yes Revise Your Diet
Banana Yes No
Pears Yes


Revise Your Diet




"Revise Your Diet " is an Error Message &
My question is how to Make this flash.. blink etc ??? bottomline is how or
is it possible to flash back such error with some effect that alerts
instantly . Like in online EXAM or poll or survey etc. How to do so in EXCEL.

I don't mean animatioin, in the scenerio above gave result "Revise Your Diet" (EXAMPLE)which is an error I want to make it auto with extra alert function so any suggession?

 

[Harlan Grove]

NovicExcel wrote...
....

in EXCEL.

I don't mean animatioin, in the scenerio above gave result "Revise Your Diet"
(EXAMPLE)which is an error I want to make it auto with extra alert function
so any suggession?

Excel provides *NO* built-in means of *CHANGING* any format
characteristic
automatically at any frequency. That means 'flashing' would be changing
cell background (interior) and text colors between two (or more?)
different
states at a frequency like once or twice per second. You could only do
that
with VBA code, and the result would noticeably degrade Excel's
performance.

If your absolutely certain you want to do this, then search the Google
Groups
archive for past threads containing the word 'flashing'.