C
cinque
--
oes716
oes716
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
post your question as body of your message
post your question as body of your message
C
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.
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.
M
Myrna Larson
Please post the exact formula you are using for your IF function.
N
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.
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.
C
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]...
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
N
NovicExcel
NovicExcel said: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?
H
Harlan Grove
NovicExcel wrote...
....
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'.
....
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'.