SOLVED
Home

Support for IF & AND function

maqboolj
New Contributor

Hi

I need support for my excel sheet

I want to do as  following 

if  A1= B2 and A2= B2, then 7- C3 otherwise it is 7

 

Maqbool

4 Replies
Solution

Hi,

=7-C3*(A1=B2)*(A2=B2)
it wouldn't be if(and(a1=b2,a2=b2),7-c3,7) ?
Thanks for your support it was excellent support and quickest
Happy new Year to you

You are welcome and all the best in this year