Thread: calculating using absolute cell reference

[whoops - sorry should have put absolute cell referencing in the title - sorry mods]

please can someone assist me as i am really stuck with a spreadsheet calculation question

Use a suitable formula to calculate : money each person has paid

spreadsheet with other data is attached.

can someone explain to me how they calculate it also, as i know i have to use absolute cell referencing but getting confused with where and how


thanks alot

Homework question?

if H2 and I2 both = TRUE then the value is 35 ......... = IF(AND(H2=TRUE,I2=TRUE),35
If they do not both =TRUE but H2 = TRUE then the value is 7.......... =IF(H2=TRUE,7
if non of the cells = TRUE then the value is 0 .......... = IF(H2=TRUE,7,0)


=IF(AND(H2=TRUE,I2=TRUE),35,IF(H2=TRUE,7,0))

Originally Posted by davesexcel

Homework question?

if H2 and I2 both = TRUE then the value is 35 ......... = IF(AND(H2=TRUE,I2=TRUE),35
If they do not both =TRUE but H2 = TRUE then the value is 7.......... =IF(H2=TRUE,7
if non of the cells = TRUE then the value is 0 .......... = IF(H2=TRUE,7,0)


=IF(AND(H2=TRUE,I2=TRUE),35,IF(H2=TRUE,7,0))

yeah, thanks alot,

so there is no need to use absolute cell referencing for this question? for example if i was to change the deposit amount etc?

cheers for the solution

Originally Posted by excelhelpme

yeah, thanks alot,

so there is no need to use absolute cell referencing for this question?

I suppose you should reference the dollar amounts under the data table, those would be absolute.
Did the class not teach about nested if statements??