If cell A1 value is 0 & C1 value is 500 then i need cell E1 result 0 but when i put any value greater than 0 in A1 cell then i need cell E1 value is same C1 value means 500 please help me how i make this formula in excel sheet
SOURCE: Excel Formulas
Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.
SOURCE: how many formulas we can use at a time in Excel
That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.
SOURCE: Disable formulas with in a work sheet of Microsoft exl
Here's an easy way to select multiple formulas:
SOURCE: what function can make a text/string BOLD?
Hi,
Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.
SOURCE: formulas in computing grades in excel
www.youtube.com/watch?v=xOU_hL2_zBo
i havent watched it, but i think it might help. hope it helps, enjoy
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
116 views
Usually answered in minutes!
×