Nested IF??

[cjohnsen]

i have a sheet that looks like so:

date name amount status
11/1/06 sherry 500 refund


can i have a formula that will return the amount provided the the name is sherry and the status is refund??

=if(b2="sherry" and d2="refund" then display c2, if not then 0...

thanks in advance for your help

[VBA Noob]

Try

=IF(AND(B2="sherry",D2="refund"),C2,0)

VBA Noob

[mudraker]

You sure can

=IF(AND(B2="sherry",D2="refund"),C2, 0)