Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Update > Entering formulas in excel

Reply
Thread Tools Display Modes

Entering formulas in excel

 
 
Mohawk
Guest
Posts: n/a

 
      05-03-2007
I am trying to enter a formula in excel. E6>G6,2,0 that bit is fine gives
the answer I want, but if E6=G6 then I want "1" diplayed, also if E6<G6 then
I want "0" zero displayed. Brackets don't seem to work neither does the help
version in the panel. Not sure what is wrong. Help would be appreciated.
Many thanks.

--
Ned
 
Reply With Quote
 
 
 
 
Joan Archer
Guest
Posts: n/a

 
      05-03-2007
You should be able to find an Excel newsgroup to ask your question as this
one is for problems with Windows Update.
Joan



Mohawk wrote:
>I am trying to enter a formula in excel. E6>G6,2,0 that bit is fine
> gives the answer I want, but if E6=G6 then I want "1" diplayed, also
> if E6<G6 then I want "0" zero displayed. Brackets don't seem to work
> neither does the help version in the panel. Not sure what is wrong.
> Help would be appreciated. Many thanks.



 
Reply With Quote
 
realcestmoi
Guest
Posts: n/a

 
      05-03-2007
Hi there,

You are posting in the wrong newsgroup, this is for issues when using
windows update only.

Best regards,
Michel Denie


"Mohawk" <> wrote in message
news:825B83C2-BE85-4A03-96E9-...
>I am trying to enter a formula in excel. E6>G6,2,0 that bit is fine gives
> the answer I want, but if E6=G6 then I want "1" diplayed, also if E6<G6
> then
> I want "0" zero displayed. Brackets don't seem to work neither does the
> help
> version in the panel. Not sure what is wrong. Help would be appreciated.
> Many thanks.
>
> --
> Ned



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word&Excel:Add-Edit Toolbar&Buttons:Autocorrect to Excel Toolbar!! Wayne4Js Windows Vista General Discussion 7 05-12-2008 05:41 AM
How to view Excel document without Microsoft Office Excel installe jl Windows Vista General Discussion 12 04-21-2008 04:53 AM
How To Get Excel File Folder to Associate with Excel File Open ncprius Windows Vista File Management 2 04-07-2008 01:38 PM
entering name in TO: Zelma Windows Vista Mail 2 07-02-2007 06:49 PM
pocket excel to excel conversion problems kevroyal Windows Update 0 12-09-2005 03:17 AM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59