| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a very simple spreadsheet for my diet
Hi
I need some help to create the simplest of spreadsheets, simple for the majority of you guys, not simple for me who is rubbish at spreadsheets. Here it is:- Food item Quantity Calories Protein(g) Carbs(g) Fat(g) A2 B2 C2 D2 E2 F3 Calories C2= B2(D2*4+E2*4+F3*9) unfortunately all as I get is #REF! I would really aprreciate someone's help Kind regards Tim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a very simple spreadsheet for my diet
It's difficult to tell the cause of the problem without having the exact data
producing #REF, but are you sure that F3 is to be used in a formula that refers to cells in row 2? Regards, Stefi "Tim" wrote: Hi I need some help to create the simplest of spreadsheets, simple for the majority of you guys, not simple for me who is rubbish at spreadsheets. Here it is:- Food item Quantity Calories Protein(g) Carbs(g) Fat(g) A2 B2 C2 D2 E2 F3 Calories C2= B2(D2*4+E2*4+F3*9) unfortunately all as I get is #REF! I would really aprreciate someone's help Kind regards Tim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a very simple spreadsheet for my diet
Select "C" cell and paste this.
=B2*(D2*4)+(E2*4)+(F3*9) Hope it helps "Tim" wrote: Hi I need some help to create the simplest of spreadsheets, simple for the majority of you guys, not simple for me who is rubbish at spreadsheets. Here it is:- Food item Quantity Calories Protein(g) Carbs(g) Fat(g) A2 B2 C2 D2 E2 F3 Calories C2= B2(D2*4+E2*4+F3*9) unfortunately all as I get is #REF! I would really aprreciate someone's help Kind regards Tim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a very simple spreadsheet for my diet
You have sharp eyes, I didn't notice that C2= is included in cell C2.
Regards, Stefi €žice€ť ezt Ă*rta: Select "C" cell and paste this. =B2*(D2*4)+(E2*4)+(F3*9) Hope it helps "Tim" wrote: Hi I need some help to create the simplest of spreadsheets, simple for the majority of you guys, not simple for me who is rubbish at spreadsheets. Here it is:- Food item Quantity Calories Protein(g) Carbs(g) Fat(g) A2 B2 C2 D2 E2 F3 Calories C2= B2(D2*4+E2*4+F3*9) unfortunately all as I get is #REF! I would really aprreciate someone's help Kind regards Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In creating a spreadsheet how can I lock a formula cell only? | New Users to Excel | |||
| a simple way to set up spreadsheet for conference rooms reservatio | New Users to Excel | |||
| Creating Spreadsheet Calculations | Excel Discussion (Misc queries) | |||
| PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions | |||
| Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions | |||
Linear Mode
