#1
|
|||
|
|||
![]() Hi can anyone help me with this ,i need to know how to write this correctly to put it in a spreadsheet
if a1=1000 and a2=1200 then a3=1
__________________
shortodds |
#2
|
|||
|
|||
![]() Quote:
=IF(AND(A1=1000,A2=1200),1,"") Assuming you want the figure 1 in cell a3, the formula goes into cell a3. |
#3
|
|||
|
|||
![]() thanks Chrome Prince,
__________________
shortodds |
Thread Tools | Search this Thread |
Display Modes | |
|
|