Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 formulas to use depending on value of another cell
Are you sure you need VBA??:
=IF(Q2="travel",ROUND((Y2/117.5*100),2),ROUND((Y2/105*100),2)) -- Gary''s Student - gsnu200857 "Sarah (OGI)" wrote: Using vba code in Excel 2003, is there any way of calculating a certain formula in one, depending on the value of another cell? For example, if Q2 contains the word 'travel', I want the following formula to operate in Z2: =round((Y2/117.5*100),2). If Q2 doesn't contain the word 'travel', I would like Z2 to use the formula: =round((Y2/105*100),2). I would then like to extend this down to last available row (which may be different each time it is run). Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting formulas depending on a variable | Excel Programming | |||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT | Excel Worksheet Functions | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
How do I change the color of a cell depending on the result of the function in that cell | Excel Programming | |||
Automated cell copy depending on cell content? | Excel Programming |