U
UKMAN
As ever many thanks in advance for any help.
I am struggling to understand how I can say not equal in an if statement in
excel
I need to consildate a table which layout is basically:
Col A Col b Col c Col d Col e
(name Car basic Bonus status)
sid 50 100 10 On hold
mary 20 50 5 approved
sid 40 90 10 rejected
sid 30 35 10 review
As this is to do with a budget the consolidation will use the same headings
but the status I want to exclude from the calc for each col is "rejected".
therefore the summary field need to say if Col a = sid, if col b = Car, if
col e not equal "Rejected" then the total car costs for sid is 80. (hope
that makes sence
As i mentioned this is a cutdown version of a large sheet.
Cheers UKMAN
I am struggling to understand how I can say not equal in an if statement in
excel
I need to consildate a table which layout is basically:
Col A Col b Col c Col d Col e
(name Car basic Bonus status)
sid 50 100 10 On hold
mary 20 50 5 approved
sid 40 90 10 rejected
sid 30 35 10 review
As this is to do with a budget the consolidation will use the same headings
but the status I want to exclude from the calc for each col is "rejected".
therefore the summary field need to say if Col a = sid, if col b = Car, if
col e not equal "Rejected" then the total car costs for sid is 80. (hope
that makes sence
As i mentioned this is a cutdown version of a large sheet.
Cheers UKMAN