Hi all,
I have created a worksheet.
http://jonnyb.homeip.net/databasedemo/package8.xls
I wish to use two formulas based upon if a column contains an instance of data. If the cell in the row is empty then formula A is to be used, else if the cell in the row contains data, formula B is to be used.
I think I could do this using Conditional Formatting but I already am using 3 conditional formulas within the rows of my worksheet. And the ADD button is grayed out.
How do I add the new formulas while still keeping the old ones?
The new formulas are to be entered in the cells of column 'ORIGINAL AMOUNT BORROWED'.
They are
(A)
(Selling Price - deposit) = Balance) = AMOUNT BORROWED
(B)
(Selling Price - deposit) = Balance)
(Balance - MGFV) = Amount Borrowed
As u can see, if the MGFV column contains a figure then the (B) calculation should be used else (A).
Any help on this would be greatly appreciated.
Thank you
Jon.
I have created a worksheet.
http://jonnyb.homeip.net/databasedemo/package8.xls
I wish to use two formulas based upon if a column contains an instance of data. If the cell in the row is empty then formula A is to be used, else if the cell in the row contains data, formula B is to be used.
I think I could do this using Conditional Formatting but I already am using 3 conditional formulas within the rows of my worksheet. And the ADD button is grayed out.
How do I add the new formulas while still keeping the old ones?
The new formulas are to be entered in the cells of column 'ORIGINAL AMOUNT BORROWED'.
They are
(A)
(Selling Price - deposit) = Balance) = AMOUNT BORROWED
(B)
(Selling Price - deposit) = Balance)
(Balance - MGFV) = Amount Borrowed
As u can see, if the MGFV column contains a figure then the (B) calculation should be used else (A).
Any help on this would be greatly appreciated.
Thank you
Jon.