Basic Excel 2000 Question?

3

3DProman

New member
Ok, I'm trying to prompt "text" to print in another cell as a result of a nested-IF formula in a different cell.

Ex: =IF(B11>B16,SUM(B11-B16)*B10,IF(B11<B16,SUM(B11-B16)*B10,IF(B11=B16,"$0.00")))

This is the formula I'm using in cell B17 to calculate the resultant variance between cells B11 and B16 * B10. No problem here it works. What I want to occur is to modify this formula in it's current cell to also print "text" in cell B18.

I do not want to write a formula in B18, but to make the above formula in B17 perform this action from it's current cell simultaneously.

Test this formula as it is, by copying this formula to cell 'B17', then enter: 5 in cell 'B10', enter: $50.00 in cell 'B11', then enter: either $50.00/$55.00/$45.00 in cell 'B16'.

Now, what I want is to insert a function in this formula that automatically prints: "equal"/"high"/"low" in cell 'B18'. How would I code this?

Not sure if it can be done, any advice appreciated!:confused:
 
The best and correct way is to copy the formula over, replace the second argument in the if statements to print text, as well as add the final else statement.

The if function is only designed to decide what is printed into the cell in which it is called. Its ability to do other things is coincidental....
 
Yes I know that is the limitation of formula and functions in a single cell. The problem is I did not know how to write the VB code for this action.
 
You must log in or register to reply here.
Back
Top