I am making a home mortgage amortization schedule. I am trying to have an IF function return data for a false reading that varies.
Here are the functions so far:

=IF(C8=0,A192, this is where the data will vary. It states the actual number of payments made depending on the value of C8. if it is true it will display the payment number in cell A192. For a false reading i need it to display whatever number of payments there will be but this number changes depending on the value in C8.

any help would be greatly appreciated.